Backing up MySQL

From The Sprawl
Jump to: navigation, search

Backup

#### wiki.sh
 
# where is the app
WIKI_HOME=/opt/docroot/mwiki
 
DB_FILE=$BACKUP_PATH/$DS\_mwikidb_db.gz
APP_FILE=$BACKUP_PATH/$DS\_mwikidb_app.tgz
 
echo 'DB FILE ' $DB_FILE
echo 'APP FILE ' $APP_FILE
 
# backup  db
/usr/bin/mysqldump -u backup mwikidb|gzip >$DB_FILE
 
 
# backup app directory
tar czf $APP_FILE -C $WIKI_HOME .

Restore

gunzip<dumps/2010_03_19_02_51_46_wiki_db.gz|mysql -u bu_user -pbuPass mwikidb
Personal tools