Bashing MySQL Dumps
Posted: July 29th, 2008 | Author: JR | Filed under: Coding | Tags: backup, bash, dumps, mysql, script, shell, sql | No Comments »A quick set of batch scripts I wrote up (two of the three scripts, anyway) for dumping all of my (specified) MySQL databases into an archive for backup. The log mailing (emailsql.pl)requires Perl and the MIME:Lite module to correctly function. I’ve also utilized a wrapper script so the log outputs to a separate file [to be mailed]. There’s also a ‘dummy’ log file I use in my crontab file, though this isn’t really necessary: