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?

Max Vernon · Answer 1 · 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 · Answer 2 · 2012-12-20 09:27:41Z

up vote 0 down vote

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

answered Dec 20 '12 at 9:27

Atropo
101

2 Answers