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
--
Alexander Foken
mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/