MySQL Forums
Forum List  »  MySQL Shell

a question about bulk importing .sql files
Posted by: xie xie
Date: August 14, 2023 11:51PM

I have serveral .sql files,i want to use mysqlshell to bulk import those .sql files into mysql,so i first connect root@localhost:3306,then i use the command:"\source C:\sip\main.sql" to import,but mysqlshell shows:"syntaxerror unexpected identifier ‘C’",the main.sql file consist of many lines like"source C:\sip\001.sql","source C:\sip\002.sql" and so on.mysqlshell‘s version is 8.0.34,mysql's version is
what is the problem?how to solve it?thank you.

Options: ReplyQuote

Written By
a question about bulk importing .sql files
August 14, 2023 11:51PM

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.