Backup bazy mysql - skrypt w shell bash:

#!/bin/bash

export d=$(date +%d)

THEDATE="${d}"

########################### CONFIGURATION START

TEMPDIR="/temp/"
ORIGDIR="/Backupy/mysql/" # original directory to put

MYSQLHOST=localhost #MySQL Host
MYSQLUSER=user # MySQL user for dump
MYSQLPASS=password # MySQL password for dump

########################### CONFIGURATION DONE
#cd ${ORIGDIR} # chdir to the right dir

mysqldump -u ${MYSQLUSER} -p${MYSQLPASS} -h${MYSQLHOST} -A > "${TEMPDIR}MySQL_${THEDATE}.sql" # dump db
tar czf ${ORIGDIR}MySQL_${THEDATE}.tar.gz ${TEMPDIR}MySQL_${THEDATE}.sql

for a in `echo "show databases" | mysql -u ${MYSQLUSER} -p${MYSQLPASS} | grep -v Database`;
do
mkdir -p ${ORIGDIR}$d/$a
echo "Dumping database: $a"
mysqldump -u ${MYSQLUSER} -p${MYSQLPASS} $a > ${ORIGDIR}$d/$a/_ALL.sql
for i in `echo "show tables" | mysql -u ${MYSQLUSER} -p${MYSQLPASS} $a| grep -v Tables_in_`;
do
echo " * Dumping table: $i"
mysqldump -u ${MYSQLUSER} -p${MYSQLPASS} $a $i > ${ORIGDIR}$d/$a/$i.sql
done
tar czf ${ORIGDIR}$d/$a.tar.gz ${ORIGDIR}$d/$a
rm ${ORIGDIR}$d/$a -R
done