导入SQL转储 [英] Import sql dump

问题描述

我正在尝试将sql转储导入mysql.我在命令提示符下选择了文件所在的目录，然后使用以下命令(从文件目录内部):

I'm trying to import an sql dump into mysql. I selected in command prompt the directory where the file is and I'm using the following command( from inside the file's directory):

mysql -u root -p password database < file.sql  

它没有显示有关此操作的任何具体细节，仅显示了我拥有的所有选项的列表，例如在帮助中.我不是mysql的高级用户，也许您有一个为什么它无法正常工作的想法.谢谢.

It doesn't show any specific detail regarding this, it just shows the list of all the options I have, like in a help. I'm not an advanced user of mysql, maybe you have an idea why it isn't working. Thanks.

推荐答案

将密码立即放在-p之后.另外，您拼错了mysql:

Place the password immediately after -p. Also, you misspelled mysql:

mysql -u root -ppassword database < file.sql  

这篇关于导入SQL转储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！