View source for Periodic backup of database

[[Main_Page|Home]] > [[Shell scripting]] > [[Useful bash shell scripts]] > [[Periodic backup of database]]

'''Use [[rsnapshot]] and [[Backing up and restoring MySQL database]] instead of below'''

Periodic backup of database can be taken by using scripts like:
<pre>
#!/bin/sh
BACKUP_DIR=<backup_dir>/$(date +%Y-%m-%d)
mkdir -p $BACKUP_DIR
mysqldump -u <user-name> -p<password> <database-name> > $BACKUP_DIR/`date +%Y-%m-%d\:%H-%M-%S`.sql

exit 0
</pre>
Replace: &lt;backup_dir&gt;, &lt;user-name&gt;, &lt;password&gt; and &lt;database-name&gt; appropriately.

This script can be put in '<tt>/etc/cron.hourly</tt>' or '<tt>/etc/cron.daily</tt>' or '<tt>/etc/cron.weekly</tt>' or '<tt>/etc/cron.monthly</tt>' based on frequency of backups desired. 

*Make sure to do 'chmod +x' on script so that it is executable.
*If you do not want to be bothered by cron output of above script then add '<tt>&gt;/dev/null 2&gt;&amp;1</tt>' at end of all commands




[[Main_Page|Home]] > [[Shell scripting]] > [[Useful bash shell scripts]] > [[Periodic backup of database]]