Dilly,
Mysql is a command line argument.
Open up a Dos box, locate the program in your <mysql\bin> directory and
run it as per below
C:\>\mysql\mysql-4.1.10a-win32\bin\mysqldump.exe -help
Usage: \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe [OPTIONS] database
[tables]
OR \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe [OPTIONS]
--databases [OPTIONS] DB1 [DB2 DB3...]
OR \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe [OPTIONS]
--all-databases [OPTIONS]
For more options, use \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe --help
Rgds
Trevor
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