Re: How to scheduled automatic backup of mysql database
The simplest approach is with mysqldump (http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html). If you want something better and are on a Linux environment, take a look at Percona Xtrabackup (http://www.percona.com/software/percona-xtrabackup/).
As for the automation, it depends on which operating system you are using. If you are on some flavor of Linux, you may use cron. If you are on Windows, create a batch script and schedule it with the task scheduler.
--
Scott Nemes
MySQL DBA
http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes
Subject
Views
Written By
Posted
3439
May 02, 2012 02:46AM
Re: How to scheduled automatic backup of mysql database
19621
May 02, 2012 12:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.