Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to do mysqldump in mysql 5.6.11?

 
Volodymyr Lysenko
Ranch Hand
Posts: 511
1
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic