bertomartin · October 17, 2013 17:48
diff --git a/backup_databash.sh b/backup_databash.sh
 #!/bin/bash

 # Backup database
 host='localhost'
 user='backup'
 passwd='secret'
 db_array=(dbname)
 bk_dir=/usr/local/backup

 for db in ${db_array[@]}; do
  mysqldump -h${host} -P3306 -u${user} -p${passwd} ${db} > ${bk_dir}/${db}_`date +%Y%m%d%H%M%S`.sql
 done

 find ${bk_dir} -mtime +30 -type f -name '*.sql'|xargs rm -f
	#!/bin/bash

	# Backup database
	host='localhost'
	user='backup'
	passwd='secret'
	db_array=(dbname)
	bk_dir=/usr/local/backup

	for db in ${db_array[@]}; do
	mysqldump -h${host} -P3306 -u${user} -p${passwd} ${db} > ${bk_dir}/${db}_`date +%Y%m%d%H%M%S`.sql
	done

	find ${bk_dir} -mtime +30 -type f -name '*.sql'\|xargs rm -f