MySQL: Shell script to backup mysql database
September 7th, 2009 by jeremychonetdy=`date +%Y-%m-%d-%H-%M` mkdir /var/backup/db_name/$tdy mysqldump -u db_user -p --opt db_name > /var/backup/db_name/$tdy/db_name-$tdy.sql
tdy=`date +%Y-%m-%d-%H-%M` mkdir /var/backup/db_name/$tdy mysqldump -u db_user -p --opt db_name > /var/backup/db_name/$tdy/db_name-$tdy.sql