linuxgizmo
Sunday, August 24, 2008
mysql backup script
#!/bin/bash

# modify the following to suit your environment
export DB_BACKUP="/var/mysql_backup"
export DB_USER="root"
export DB_PASSWD=""

# title and version
echo ""
echo "mySQL_backup"
echo "----------------------"
echo "* Rotating backups..."
rm -rf $DB_BACKUP/07
mv $DB_BACKUP/06 $DB_BACKUP/07
#mv $DB_BACKUP/06 $DB_BACKUP/07
mv $DB_BACKUP/05 $DB_BACKUP/06
mv $DB_BACKUP/04 $DB_BACKUP/05
mv $DB_BACKUP/03 $DB_BACKUP/04
mv $DB_BACKUP/02 $DB_BACKUP/03
mv $DB_BACKUP/01 $DB_BACKUP/02
mkdir $DB_BACKUP/01

echo "* Creating new backup..."
#mysqldump --user=$DB_USER --password=$DB_PASSWD mysite-db11| bzip2 > $DB_BACKUP/01/mysite-db11-`date +%Y-%m-%d`.bz2
#mysqldump --user=$DB_USER --password=$DB_PASSWD mysql| bzip2 > $DB_BACKUP/01/mysql-`date +%Y-%m-%d`.bz2
/usr/local/mysql/bin/mysqldump --user=$DB_USER --password=$DB_PASSWD mysite-db11 > $DB_BACKUP/01/mysite-db11-`date +%Y-%m-%d`.sql
/usr/local/mysql/bin/mysqldump --user=$DB_USER --password=$DB_PASSWD mysql > $DB_BACKUP/01/mysql-`date +%Y-%m-%d`.sql
echo "----------------------"
echo "Done"
exit 0
posted by Venkat Raman V @ 4:05 PM  
0 Comments:
Post a Comment
<< Home
 
Come Lets Share LINUX Info.
Select Topics
  • CORE LINUX
  • APACHE
  • Solved Errors
  • Scripts
    •
Watz HOT