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
408
August 14, 2023 11:51PM


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.