This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Backing up database through java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Backing up database through java" Watch "Backing up database through java" New topic

Backing up database through java

Divakar Sashwanth

Joined: Apr 17, 2005
Posts: 11
Hi to every one
I have a doubt in java regarding creating the MySQL database dump.

My problem is...

i have a huge content in the database. i need to take a backup of the database on every day as i boot my system or as i open the application.

i am right now using a MySql Database 4.1.12 version. i just need to have a database backup..
how can i get that..

i know that thru the command promt or thru the shell prompt i can create a back up thru the syntax mysqldump -uusername -ppassword databasename > filename

but how do i achieve that thru Java..
my application work on a desktop machine where mysql server and the application are installed..

i need to backup the database and if possible compress the database dump file

I hope i will get a solution for this query

Thanks in advance

Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
Hi, welcome to the ranch!

I don't know if MySQL has any APIs for this, so I'll assume it doesn't and go from there. It would be simplest to do the backup outside Java. Maybe make a batch or shell script to perform the backup and launch the Java app and invite the users to run that instead of starting Java. To run it from Java make a script that does the backup only and invoke it via Runtime.exec(). There's a bit more work to get that going, but it might be slick to have a "backup now" button inside your application.

BTW: The sheriff will doubtless be around to remind you that your user name must be a believable first & last name.

A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 60760

On cue...


There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Forum Bartender
[ July 18, 2005: Message edited by: Bear Bibeault ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
MySQL has an administration GUI, that will allow you to backup as well as restore MySQL databases.

MySQL Administrator

Give it a try.
Anand Karia
Ranch Hand

Joined: Sep 25, 2004
Posts: 156

I agree with both of them.

"To run it from Java make a script that does the backup only and invoke it via Runtime.exec(). There's a bit more work to get that going, but it might be slick to have a "backup now" button inside your application".

and Mr. Craig. using tools.

Love is GOD and GOD is Love.
Anand Karia
IT Concretor.......
M/s. Anand Karia Concreting IT
I agree. Here's the link:
subject: Backing up database through java
Similar Threads
Get database Backup in MySQL
Taking backuop in Every miniute
Back of database
Using MySQL for work and Cattledrive at same time?
Need External Back Up in Java Web Application