my_coldbackup_database.sh

w_date=$(date '+%Y_%m_%d_%H_%M_%S')

# avec generation log
# su mysql --command="mysqlbackup --user=root --password=motdepasse --ibbackup=/opt/mysql/meb-3.5/bin/ibbackup /etc/mysql/my.cnf /data/backups/mysql" > /exploit/logs/my-backup-${w_date}.log

# sans log pour remonter dans VTOM
su mysql --command="mysqlbackup --user=root --password=motdepasse --ibbackup=/opt/mysql/meb-3.5/bin/ibbackup /etc/mysql/my.cnf /data/backups/mysql"

[root@pdtb2 scripts]# cat my_coldbackup_database.sh
#w_date=$(date '+%Y_%m_%d_%H_%M_%S')
w_date=$(date '+%A')

BACKUPDIR=/data/backups/mysql/${w_date}_coldbackup
DATADIR=/data/mysql

echo "rm -rf $BACKUPDIR"
rm -rf $BACKUPDIR

echo "stop mysql database"
/exploit/scripts/my_stop_database.sh

su mysql --command="mkdir $BACKUPDIR"

echo "copy my.cnf"
cp -p /etc/mysql/my.cnf $BACKUPDIR/

echo "copy database sans compression"
time cp -rp $DATADIR/ $BACKUPDIR/

echo "start mysql database"
/exploit/scripts/my_start_database.sh

sleep 120