19 lines
438 B
Bash
Executable File
19 lines
438 B
Bash
Executable File
#!/bin/bash
|
|
|
|
BACKUPDIR=/var/lib/dbbackup
|
|
NOW=`date +%Y%m%d%H%M`
|
|
|
|
mkdir -p $BACKUPDIR
|
|
chown root:root $BACKUPDIR
|
|
chmod og-rwx $BACKUPDIR
|
|
|
|
touch $BACKUPDIR/mysqldump-$NOW.sql
|
|
chmod 400 $BACKUPDIR/mysqldump-$NOW.sql
|
|
|
|
# Backup full DB
|
|
sudo nice mysqldump -p -u `cat /root/.mysqluser` -h `cat /root/.mysqlhost` -p`cat /root/.mysqlpw` `cat /root/.mysqldb` > $BACKUPDIR/mysqldump-$NOW.sql
|
|
|
|
# Compress it
|
|
nice xz $BACKUPDIR/mysqldump-$NOW.sql
|
|
|