highfocus — 2011-04-23T11:53:00-04:00 — #1
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...
r937 — 2011-04-23T13:32:00-04:00 — #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
highfocus — 2011-04-23T15:36:03-04:00 — #3
Thanks for the reply r937....Your book is definately on my list....