I have a problem in taking backup of mysql dump in my windows xp machine. I have a database called dvd. i want to take the backup of this database so i tried the following, but it gives error.So i got doubt, whether the following commands should be executed in teh "mysql>" prompt or in some other place. Please give me a result.
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 since i am new to mysql i dont know where to execute this commands. please give me a result. -- Friendly, Raja.M
