1

I try to clone my_db to my_db_clone. I followd this post and this but I get always

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

I tried thise but none worked, I get always that error : 

mysqldump -u my_user -p my_db | mysql -u backup -pmy_password my_db_clone

mysqldump my_db | mysql my_db_clone;

mysqldump my_db -u my_user -pMy_passwprd > dumpdb.sql;
Community
  • 1
  • 1
user2997418
  • 648
  • 1
  • 8
  • 22

1 Answers1

1

The mysqldump utility runs in the shell. How are you invoking it? Based on your error message, it appears that you might be trying to run it in the mysql client.

Try it in the shell instead.

Ike Walker
  • 64,401
  • 14
  • 110
  • 109