An error occurred when MySQL backup with mysqldump instruction in MacOS system

Error 1064 (42000) from mysqldump command

Mysqldump – uroot – P library name & gt/ Backup path/backup file name. SQL;

Always report 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 -uroot -p bank>/ Users/F/bank_ back.sql’ at line 1

resolvent:

Input mysqldump command directly in the terminal, do not input mysqldump command after logging into the database.

Special thanks to the original author guanggulala.


Read More: