CODEWITHSUNDEEP
mysql
Luquan Li
Luquan Li

Reputation: 1

Mysqldump not working in mac

I have a question of mysqldump in mac terminal.

mysql>mysqldump -u user -ppassword database;

But it says:

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

I do not know why.

Upvotes: 0

Views: 1384

Answers (2)

Parias Lunkamba Mukeba
Parias Lunkamba Mukeba

Reputation: 302

you can remedy this by issuing the following instruction: ln -s /usr/local/zend/mysql/tmp/mysql.sock /tmp/mysql.sock

Upvotes: 0

Barmar
Barmar

Reputation: 780655

You run mysqldump from the shell, not inside the mysql command.

Upvotes: 3

Related Questions