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".
and Mr. Craig. using tools.
This thread has been viewed 1180 times.
All times above are in ranch (not your local) time.
The current ranch time is Oct 21, 2018 02:46:31.