今天我在使用mysqldump进行备份时,发生报错,以下是我用于备份数据库的命令:
mysql> mysqldump -hlocalhost -uroot -p myempoyees student > "D:/backup/file.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 -hlocalhost -uroot -p myempoyees student >
"D:/backup/file.sql"' at line 1
但命令应该是对的
经过网上查询得出结果:mysqldump不是MySQL命令,而是命令行使用程序,必须使用Shell命令行调用它。
在Shell命令窗口执行语句即可,不需要进入MySql命令
C:\Program Files\MySQL\MySQL Workbench 8.0>mysqldump -hlocalhost -uroot -p myempoyees student >"D:/backup/file.sql"
Enter password: ******
C:\Program Files\MySQL\MySQL Workbench 8.0>
输入密码,备份成功!