File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB Backup - MySql" Watch "DB Backup - MySql" New topic

DB Backup - MySql

yaron re

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
jQuery in Action, 2nd edition
subject: DB Backup - MySql