yesmeck · October 27, 2011 05:13
diff --git a/mysql_backup.sh b/mysql_backup.sh
 #!/bin/bash

 max_file_count=15
 file_count=$(ls mysql-* | wc -l)

 if [ $file_count -gt $max_file_count ]
 then
    rm mysql-*
 fi

 current_dir=$(dirname $0)
 now=$(date +%Y-%m-%d)
 db_user="root"
 db_password="asdf"

 mysqldump --user=$db_user --password=$db_password --all-databases > $current_dir/mysql-$now.sql

 exit 0
	#!/bin/bash

	max_file_count=15
	file_count=$(ls mysql-* \| wc -l)

	if [ $file_count -gt $max_file_count ]
	then
	rm mysql-*
	fi

	current_dir=$(dirname $0)
	now=$(date +%Y-%m-%d)
	db_user="root"
	db_password="asdf"

	mysqldump --user=$db_user --password=$db_password --all-databases > $current_dir/mysql-$now.sql

	exit 0