File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes How to do mysqldump in mysql 5.6.11? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to do mysqldump in mysql 5.6.11?" Watch "How to do mysqldump in mysql 5.6.11?" New topic
Author

How to do mysqldump in mysql 5.6.11?

Volodymyr Lysenko
Ranch Hand

Joined: Mar 29, 2012
Posts: 511
    
    1

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!


    True person is moral, false is right!
     
    wood burning stoves
     
    subject: How to do mysqldump in mysql 5.6.11?
     
    It's not a secret anymore!