Problem using mysqldump command

Databases
1

Hello everyone,

I am using the mysql program along with phpMyAdmin to run mysql queries and am having problems using the mysqldump command. This is the command line that should backup my database and put it in the file full_backup.sql:

mysqldump -u root -p mypassword --all-databases > full_backup.sql

When I put this command in my mysql command line client or the phpMyAdmin client I get this error:

“#1064 - 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 ‘mysqldump -u root -p mypassword --all-databases >full_backup.sql’ at line 1”

Can someone help me with this…

Thanks A lot…

2

mysqldump is a shell command, not a mysql command – you don’t run it from within phpmyadmin

in fact, you don’t have to run it at all, because phpmyadmin has a backup feature built in

3

Thanks for the reply r937…Your book is definately on my list…