File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure 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
  • 0
  • 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!
     
    I agree. Here's the link: http://aspose.com/file-tools
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic