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
221
February 26, 2023 11:31PM
90
February 27, 2023 07:50AM
87
February 27, 2023 12:34PM
72
February 28, 2023 12:46PM


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.