The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
MysqlHotCopy backup script
I'm looking for a backup solution that will:
- shut down forums with a custom 'backup in progress' message - execute mysqlhotcopy to backup specified DB's to specified dir - roll over backups to keep only x number backups on file - reopen forums The following is a script posted by masalaman over at vb.com. It does everything except shut down / open the boards: Code:
#!/bin/sh # List of databases to be backed up separated by space dblist="testdb" # Directory for backups backupdir=/home/mysql/backup # Number of versions to keep numversions=4 # Full path for MySQL hotcopy command hotcopycmd=/usr/bin/mysqlhotcopy # MySQL Username and password userpassword=" --user=root --password=password" # Create directory if needed mkdir -p ${backupdir} if [ ! -d ${backupdir} ] then echo "Invalid directory: ${backupdir}" exit 1 fi # Hotcopy begins here echo "Hotcopying MySQL Databases..." RC=0 for database in $dblist do echo "Hotcopying $database ..." $hotcopycmd $userpassword $database ${backupdir} RC=$? if [ $RC -gt 0 ] then break; fi # Rollover the backup directories i=$numversions mv ${backupdir}/${database} ${backupdir}/${database}.0 2> /dev/null rm -fr ${backupdir}/${database}.$i 2> /dev/null while [ $i -gt 0 ] do mv ${backupdir}/${database}.`expr $i - 1` ${backupdir}/${database}.$i 2> /dev/null i=`expr $i - 1` done done if [ $RC -gt 0 ] then echo "MySQL Hotcopy failed!" exit $RC else # Hotcopy is complete. List the backup versions! ls -l ${backupdir} echo "MySQL Hotcopy is complete!" fi exit 0 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|