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 5.7.43.0.
what is the problem?how to solve it?thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
a question about bulk importing .sql files
70
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.