I have ubuntu 14 (nginx) and I’m ran that command to duplicate/export my database:
mysqldump -u[user] -h[localhost] -p[pwd] database1 > /home/database1.sql
And after I ran to import:
mysql -u[user] -h[localhost] -p[pwd] database2 < /home/database1.sql
And I get that message:
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 ‘mysql neurocriativi > /home/neurocriativi.sql’ at line 1
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.