error 1064(42000):you have an error in your ssql syntax;check the manual that corresponds to your mysql server version for the right syntax to use near'mysqldump -h localhost -u root -p student > student_backup.sql;' at line 1 提示错误就是这个!!!! 我想对于这个命令提示错误的话只会提示这个信息,所以就没贴了 等高手解答
这个命令不是在MYSQL中使用,是在DOS命令行下使用。
在mysql环境下执行 mysqldump 命令出现以后错误:mysql> mysqldump -uroot -pfunmobile -h127.0.0.1 zawapdb wap_settings>E:log\wap_settings.sql; Show warnings disabled. 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 -uroot -pfunmobile -h127.0.0.1 zawapdb wap_settings>E:logap_settings.s' at line 1 在DOS命令行下使用:C:\Documents and Settings\user>mysqldump -uroot -pfunmobile -h127.0.0.1 zawapdb wap_settings>E:log\wap_settings.sql在E盘log文件夹下生成了wap_settings.sql 文件备份成功!最后提醒一点: 在mysql命令模式下 需输入 “;”, 在dos命令行下 备份的时候 无需输入 “;”,否则将出现错误:C:\Documents and Settings\user>mysqldump -uroot -pfunmobile -h127.0.0.1 zawapdb wap_setting>E:log\wap_settings.sql; mysqldump: Couldn't find table: "wap_setting;" Thanks!
mysqldump -h localhost -uroot -p student>student_backup.sql;
写在shell或者cmd环境下
是在命令行下(mysql command line client)运行的
开始->程序->运行->CMD->进入MYSQL目录->mysqldump -h localhost -uroot -p student>student_backup.sql;
提示错误就是这个!!!!
我想对于这个命令提示错误的话只会提示这个信息,所以就没贴了
等高手解答
Show warnings disabled.
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 -uroot -pfunmobile -h127.0.0.1 zawapdb wap_settings>E:logap_settings.s' at
line 1
在DOS命令行下使用:C:\Documents and Settings\user>mysqldump -uroot -pfunmobile -h127.0.0.1 zawapdb wap_settings>E:log\wap_settings.sql在E盘log文件夹下生成了wap_settings.sql 文件备份成功!最后提醒一点:
在mysql命令模式下 需输入 “;”,
在dos命令行下 备份的时候 无需输入 “;”,否则将出现错误:C:\Documents and Settings\user>mysqldump -uroot -pfunmobile -h127.0.0.1 zawapdb wap_setting>E:log\wap_settings.sql;
mysqldump: Couldn't find table: "wap_setting;"
Thanks!