Skip to content
Advertisement

Getting syntax error while exporting mysql database

I have cPanel trial version installed on the centOS server which is expired now. So I don’t have access to cPanel user and WHM login.

I am tried the following mysql> mysqldump -u root –ppassword db_name > db_nametext.sql;

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 -u root –ppassword db_name > db_name at line 1

Thank you for time and consideration.

Advertisement

Answer

You cannot run mysqldump from mysql shell: mysqldump is not a SQL statement but an executable that must be run from linux shell like mysql command.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement