blob: 97799de49f96c62a372f36f0d80e620dd202612b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
#!/bin/bash
DC=$(/bin/date +%Y%m%d)
BK_DIR="$HOME/MySQL/mysql-backup-$DC"
##mysqldump -A --opt --add-drop-database --order-by-primary --hex-blob |gzip -9 > mysql-backup-$DC.sql.gz
[ -d $BK_DIR ] || mkdir -p $BK_DIR
cd $BK_DIR
for TBL in $( mysql -e 'show databases;' |cat ) ; do
echo "Backing up $TBL"
/usr/bin/mysqldump --opt --add-drop-database --order-by-primary --hex-blob $TBL > $BK_DIR/$TBL.sql
done
cd $BK_DIR/..
echo "Archiving to mysql-backup-$DC"
zip -9myroq $BK_DIR mysql-backup-$DC
#EOF
|