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...