Make a backup from a Mysql database
Easy way to dump a mysql database
#!/bin/bash
DATE=`date +%Y-%m-%d`
mysqldump --user dbuser --password=dbpasswd database > database-dump.sql
tar cvfz database-dump$DATE.tar.gz database-dump.sql
rm database-dump.sql
exit 0
|
|
Description
Add this script to the cron and you allways have a backup.
Example:
30 4 * * * cd /backups && sh mysql_db_backup.sh
Top
