mysql 备份语句到底改怎么写?
有这么个数据库blog 我想要导入到c盘根目录下的 test.sql下(或者当前目录)
语句该怎么写?
mysql> mysqldump -u root -p blog >test.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 -u root -p blog >test.sql' at line 1
mysql> mysqldump -u root -p blog > test.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 -u root -p blog > test.sql' at line 1
mysql> mysqldump -uroot -pblog > test.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 -uroot -pblog > test.sql' at line 1
mysql>
为什么老是不对?