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
Post by:Stan James
, Ranch Hand
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.
"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".