mysqldump error 1064 — Solved – How to use the mysqldump command (video)
As I was trying to backup my mysql database with the following command:
mysql> mysqldump -uuser -ppass databaseDB > output.sql
(where user is the username, pass is the password, and databaseDB is the database name)
I continued to receive the following error:
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 ‘mysqldump’ at line 1.
After some searching I realized that my syntax was correct, but I was putting the command in the wrong place!
The mysqldump command needs to run from the command prompt (for windows), NOT in the mysql console!
That’s it. Problem solved!
Here is a video that will walk you through basic usage of the mysqldump command:
Related Posts
5 Comments
Leave a reply
We are currently offering a free copy of our 16-page eBook, "How to Organize your Digital Photography Collection" to everyone who signs up for our free newsletter. This eBook will review how to organize your digital photos, discuss metadata, and give you an overview of software than can help you with your digital photography workflow. Sign up in the signup area, located in the right-side column of every page on this site, and read your copy now!
vijayaJune 4, 2010 at 2:42 pm
Hi thankyou very much, saved my day.
RomanArtOctober 25, 2010 at 8:12 pm
Yes! This helped me thanx! Even though I am on a Mac I was able to understand perfectly.
anandMarch 10, 2011 at 12:51 pm
thanx dude…… i have been exploring the entire manual for this….
john giannakMarch 2, 2012 at 8:50 am
Thanx very much, I have been searcing for many minutes for this!
Robyn PolanApril 3, 2012 at 10:34 am
Many Thanks. I have also spent hours reading the manual and find it frustrating that this was not made clear.