CODEWITHSUNDEEP
mysql
user2997418
user2997418

Reputation: 658

Issue to clone mysql DB

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;

Upvotes: 1

Views: 51

Answers (1)

Ike Walker
Ike Walker

Reputation: 65537

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.

Upvotes: 1

Related Questions