导出mysql错误1064 :在sql语法中有错误。

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

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