Tuesday, July 3, 2012

[SQL] Error 1064 42000 mysqldump Fix

You may be running into the following Error 1064 (42000) while trying to do a mysqldump in mysql. Your problem is that you are trying to do it *in* mysql.

Wrong way:

mysql> mysqldump -u cookie -pPASS1234 coffee_shop > yourFile.sql

Right way:
1. Connect to your ssh in PuTTY
2. Try your mysqldump query now.
3. ???
4. Profit!!!


Post a Comment