Search the Community
Showing results for tags 'script backup mysql'.
Found 1 result
-
#!/bin/sh # Backup Baze de date MySQL b_dir="/usr/BACKUP/" log_dir="/var/log/backup/" MySQL_db_dir="/usr/local/mysql/var/" MySQK_bk_user="userul de backup" MySQL_bk_pw="Parola pentru userul de backup" mkdir $b_dir`date +"%d%b%y"` mkdir $b_dir`date +"%d%b%y"`/mysql/ # MySQL for i in `ls $MySQL_db_dir | sed -e 's/\///'` ; do if [ -d $MySQL_db_dir$i ] ; then cd $b_dir`date +"%d%b%y"`/mysql/ /usr/bin/mysqldump $i -u $MySQL_bk_user -p"$MySQL_bk_pw" > $i-`date +"%d%b%y"`.sql tar cjf $i-`date +"%d%b%y"`.sql.tar.bz2 $i-`date +"%d%b%y"`.sql rm -rf $i-`date +"%d%b%y"`.sql fi done sursa: www[.]linux-tutorial[.]eu
