mysql在命令提示符号下怎么恢复和备份数据库?我用mysqldump命令,老提示错误:
mysql> mysqldump databasespjk101;
1064 - 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 databasespjk101' at line 1
mysql>
我看用户手册上都是在shell下用mysqldump,到底改怎么弄啊???高手解决一下啊~
mysql> mysqldump databasespjk101;
1064 - 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 databasespjk101' at line 1
mysql>
我看用户手册上都是在shell下用mysqldump,到底改怎么弄啊???高手解决一下啊~
2、在系统SHELL下
mysql -uroot -p<123.SQL
mysql> select * into outfile 'xxx.txt' from 表;
LZ 说的 mysqldump 那是在系统命令行,在 mysql 控制台中当然不行。
eg:mysql>mysqldump -uroot -proot first > c:/backup/first.txt