mysqldump is not a mysql command. Invoke it from your command line, just as you invoke mysql from the command line.
On 1/30/06 6:45, "Alexander Foken" <[EMAIL PROTECTED]> wrote: > You may want to ask your question on a mysql mailing list, this is a DBI > mailing list. > > Are you sure "mysqldump" is a command of the mysql monitor and not an > independant program? > > Alexander > > > Dilly raja wrote: > >> 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 >> >> >> >
