posted 10 years ago
Hello!
I use mysql 5.6.11 for windows xp.
I can't anyway write correct mysqldump command:
I tried among all:
mysqldump -u root -p 123456 my_db_name > D:/jh_backup.sql;mysqldump --user=root --password=123456 my_db_name > D:/jh_backup.sql;mysqldump -uroot -p123456 my_db_name > D:/jh_backup.sql;mysqldump -u root -p 123456 my_db_name > jh_backup.sql;mysqldump -opt -u root -p 123456 my_db_name > D:/jh_backup.sql;
And they all failed. I always got this error:
You have an error in your sql syntax, check the manual that coresponds to you mysql server version for the right syntax to use near 'my_query' at line 1
Does anybody did mysqldump on mysql 5.6.11 correctly?
Thanks!
To earn money on java go to upwork.com