[Logo]
Forums Register Login
Backing up database through java
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
==========
Divakar
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.
On cue...

"Divakar",

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.

Thanks!
bear
Forum Bartender
[ July 18, 2005: Message edited by: Bear Bibeault ]
MySQL has an administration GUI, that will allow you to backup as well as restore MySQL databases.

MySQL Administrator

Give it a try.
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.
Wink, wink, nudge, nudge, say no more ... https://richsoil.com/cards


This thread has been viewed 1122 times.

All times above are in ranch (not your local) time.
The current ranch time is
May 26, 2018 01:54:14.