MySQL database backup every day using java code

Question

We are developing a Java web application using Spring, Hibernate and MySQL.

I want our application to automatically backup the MySQL database daily; is there any way to accomplish that with Java code?

u may use one facility of mysql that can be rollback the data of your database — Dhaiwat budh
– Dhaiwat budh, Commented Sep 9, 2012 at 17:44

Hannah Vernon · Accepted Answer · 2012-09-10 13:45:27Z

This is easy to do.

Write a script to create the backup using the "mysqldump" tool available at http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html - Google "mysql backup unix/windows script" to find some examples.
Use a task scheduler to run this script. On UNIX this could be "cron", Windows as a "task scheduler". Best to do so at times when the app is under low-usage.

It is worth while putting some backup file cycling into the script so that you keep, say, every backup from the last week and delete the rest.

Also remember to backup to a physically different disk from the database itself so you have a backup if the disk dies.

Atropo · Accepted Answer · 2012-12-20 09:27:41Z

0

You can user Quartz-scheduler to schedule the backup, take a look here on how to schedule an automatic Hibernate backup.

answered Dec 20, 2012 at 9:27

Atropo

1613 bronze badges

2 Answers 2