MySQL Forums
Forum List  »  MySQL Shell

Re: mysqlsh parallel import error
Posted by: Sanjay Gupta
Date: February 27, 2023 12:34PM

still unable to make it work
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

mysql> desc test.sanjay_test1
-> ;
+-------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------+------+-----+---------+-------+
| INTF_ID | int(11) | YES | | NULL | |
| BATCH_JOB_NO | int(11) | YES | | NULL | |
| STATUS_CODE | int(11) | YES | | NULL | |
| MESSAGE | varchar(1000) | YES | | NULL | |
| MESSAGE_TIMESTAMP | datetime | YES | | NULL | |
+-------------------+---------------+------+-----+---------+-------+
5 rows in set (0.03 sec)

mysql>

Tried 3 different options so even single quote and double quotes errors are different.

mysqlsh --uri=mysql://root:xxx@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: The following option is invalid: --linesTerminatedBy=

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

WARNING: Using a password on the command line interface can be insecure.
ERROR: Target table is not set. The target table for the import operation must be provided in the options.

mysqlsh --uri=mysql://root:xxx@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: Target table is not set. The target table for the import operation must be provided in the options.

Options: ReplyQuote


Subject
Views
Written By
Posted
201
February 26, 2023 11:31PM
79
February 27, 2023 07:50AM
Re: mysqlsh parallel import error
79
February 27, 2023 12:34PM
66
February 28, 2023 12:46PM


Sorry, only registered users may post in this forum.

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.