It's not a secret anymore!*
The moose likes JDBC and the fly likes DB Backup - MySql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB Backup - MySql" Watch "DB Backup - MySql" New topic
Author

DB Backup - MySql

yaron re
Greenhorn

Joined: Jun 29, 2007
Posts: 7
How can I create DB Backup to a dump file or zip file from java code?
I can only create "sql" files. while the file i need is "zip" or "dump".
Is there any way doing that???
Tim McGuire
Ranch Hand

Joined: Apr 30, 2003
Posts: 820

Simplest way would be turn it into a two part process:
Take the .sql file you have produced and run it through a zip file creation process.

here is instructions to get you started with zip file creation:
Creating a ZIP file
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DB Backup - MySql