Posted By

xnet74 on 01/08/11

Tagged

mysql
Bash

Versions (?)

Last Edited at 01/08/11 01:56pm

Statistics

Viewed 737 times

Favorited by 0 user(s)

Related snippets

Small MySQL backup shell script

/ Published in: MySQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

#!/bin/bash
 
#set -x
#set $(date)
#str_Tag=$(date +%A);
 
BACKUP_DIR="/backup_mysql"
MYSQL_PWD="secretPass"
 
echo "********** saving MySQL-Databases ****"
DBASELIST=`mktemp`
mysqlshow -p$MYSQL_PWD | awk '{print $2}' | grep -v Databases | sort >$DBASELIST
 
# Wohin sollen die ganzen Backups geschrieben werden?
cd $BACKUP_DIR
 
# letztes Backup nach $BACKUP_DIR/last verschieben
mv $BACKUP_DIR/*gz $BACKUP_DIR/last/
 
# MySQL Cache auf HDD schreiben und Tabellen vor Veraenderungen schuetzen
mysql -u root -p$MYSQL_PWD mysql -e "flush tables with read lock" -v
 
# Sicherung der einzelnen Tabellen
for x in `cat $DBASELIST`; do
	echo "    saving database: $x";
	mysqldump --opt -p$MYSQL_PWD $x >$x.sql;
	tar cfvz $x.tar.gz $x.sql > /dev/null 2>&1
	rm $x.sql
done;
 
# Tabellen nach der Sicherung wieder freigeben
mysql -u root -p$MYSQL_PWD mysql -e "unlock tables" -v
echo -e "\033[40;1;32m Done \033[0m..."
echo ""