PDA

View Full Version : mysqldump error


rajadilly
01-30-2006, 06:15 AM
lI am new the mysql. I am using a database called "dvd" in a windows xp system. i want to take a backup of my database, so i issued the following commands, but everything created error, so i am in doubt that whether these command should be executed in the mysql> prompt or someother promp. If it is mysql prompt tell me the proper command for taking the backup. The following are the errors i got.

Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 306 to server version: 5.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use dvd
Database changed
mysql> mysqldump dvd>c:\mysqldump\backupfile.sql
ERROR:
Unknown command '\m'.
ERROR:
Unknown command '\b'.
-> ;
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 dvd>c:\mysqldump\backupfile.sql' at line 1
mysql> mysqldump dvd>backupfile.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 dvd>backupfile.sql' at line 1
mysql> mysqldump -u root -p autoraja dvd>backup.sql
-> mysqldump -u admin -p admin accounts>accounts.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 autoraja dvd>backup.sql
mysqldump -u admin -p admin account' at line 1
mysql>

GJay
01-30-2006, 08:12 AM
mysqldump is a commmand external to mysql, just run it from the commandline