error 1064(42000) while trying to execute mysqldum

问题:

This question already has an answer here:

• Error while taking backup with mysqldump in mysql command line 5 answers

im trying to run the following command: mysql> mysqldump --all-databases > dump.sql; on my local(On my pc) Mysql 5.5 server but I keep getting this error:

mysql> mysqldump --all-databases > dump.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 'mysql
dump --all-databases > dump.sql' at line 1.

回答1:

mysqldump is a command you invoke at the shell prompt, not within the mysql client environment.

mysql> exit
$ mysqldump --all-databases > dump.sql

回答2:

You must execute that command from the system shell, don't forget to use username and password to access all databases, example:

mysqldump -u root -p --all-databases > dump.sql