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
284
February 26, 2023 11:31PM
128
February 27, 2023 07:50AM
Re: mysqlsh parallel import error
130
February 27, 2023 12:34PM
116
February 28, 2023 12:46PM
123
March 01, 2023 03:28PM
116
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.