MySQL Forums
Forum List  »  MySQL Shell

mysqlsh parallel import error
Posted by: Sanjay Gupta
Date: February 26, 2023 11:31PM

~ % cat test3.csv
0,0,0,"run_intf_filter is handling Data Source ID 15.",2023-01-25 02:32:38
0,0,0,"No records to filter for 15!",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 17.",2023-01-25 02:32:38
0,0,0,"No records to filter for 17!",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 21.",2023-01-25 02:32:38
0,0,0,"Calling INTF_FILTER.process_cddb2_interface()...",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 23.",2023-01-25 02:32:38
0,0,0,"Calling INTF_FILTER.process_cddb2_interface()...",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 47.",2023-01-25 02:32:38
0,0,0,"No records to filter for 47!",2023-01-25 02:32:38


mysqlsh --uri=mysql://root:xxxx@localhost:3306 -- util import-table test3.csv --schema=test table=sanjay_test1 --linesTerminatedBy="\n" --fieldsTerminatedBy=","

WARNING: Using a password on the command line interface can be insecure.
ERROR: Argument options: Separators cannot be the same or be a prefix of another.


Any idea why mysqlsh is giving error ? I have tried various combinations and unable to figure out correct syntax .

This works fine from mysql command line....

LOAD DATA INFILE '/Users/sagupta/test3.csv'
INTO TABLE sanjay_test
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlsh parallel import error
317
February 26, 2023 11:31PM
143
February 27, 2023 07:50AM
141
February 27, 2023 12:34PM
127
February 28, 2023 12:46PM
148
March 01, 2023 03:28PM
128
March 01, 2023 04:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.