Quick DB dumps with automatic file name generation based on date/time
Filed Under (Databases, Linux) by admin on 27-12-2009
Simple DB backup
mysqldump -h [server name] -u [user name] [db name] -p > site-db-`date +%y%m%d-%H%M`.sql
Complete MySQL dump with compression
mysqldump –all-databases -u admin -p`cat /etc/psa/.psa.shadow` > `hostname -s`-mysql-`date +%y%m%d`.sql
tar zcf `hostname -s`-mysql-`date +%y%m%d`.tgz `hostname -s`-mysql-`date +%y%m%d`.sql
rm `hostname -s`-mysql-`date +%y%m%d`.sql
Complete HTTP sites data with compression
cd /var/www/vhosts/
tar zcf `hostname -s`-sites-`date +%y%m%d`.tgz * –exclude=*/statistics/* -v –exclude=ilatina.com/httpdocs/downloads/
mv `hostname -s`-sites-`date +%y%m%d`.tgz /root/.data/`hostname -s`
