I have seen many replies to this question, but none of the solutions worked for me, so i am repeating the same question. I am using mysql 5.5.30 on windows xp. I am able to open mysql command line by giving this command:d:\mysql\usr\local\mysql\bin>mysql –uroot –proot
我已经看到了很多对这个问题的回答，但是没有一个解决方案对我有效，所以我重复同样的问题。我在windows xp上使用的是mysql 5.5.30。我可以通过这个命令打开mysql命令行:d:\mysql\usr\本地\mysql\bin>mysql -uroot -proot。
But when i use the same username and password to export a database by giving this command:mysql>mysqldump -uroot -proot svga3 > dbsqlfile.sql
I GET THIS ERR:
但是，当我使用相同的用户名和密码来导出数据库时，使用这个命令:mysql>mysqldump -uroot -proot svga3 > dbsqlfile。sql我犯了一个错误
Error 1064 <42000>: You have an error in your sql syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -uroot -proot svga3 > dbsqlfile.sql
AFTER seeing many on responses and tried all combinations of the same line, it does't work, need help!
在看到许多回复并尝试了同一条线的所有组合后，它就不起作用了，需要帮助!
Other option tried:
尝试其他选择:
mysqldump -u root -p root svga3 > dbsqlfile.sql
mysqldump -uroot -p svga3 > dbsqlfile.sql
mysqldump -u root -p=root svga3 > dbsqlfile.sql
mysqldump -u -p svga3 > dbsqlfile.sql
1 个解决方案
#1
1
You can't run mysqldump from a mysql shell, it needs to run from the prompt.
您不能从mysql shell中运行mysqldump，它需要从提示符运行。
d:\mysql\usr\local\mysql\bin>mysqldump ...
d:\ mysql \ usr \本地mysql \ bin \ >,mysqldump…
#1
1
You can't run mysqldump from a mysql shell, it needs to run from the prompt.
您不能从mysql shell中运行mysqldump，它需要从提示符运行。
d:\mysql\usr\local\mysql\bin>mysqldump ...
d:\ mysql \ usr \本地mysql \ bin \ >,mysqldump…