MySQL – Use mysqldump and FTP the Backup Files Offsite via Perl
6 de abril de 2016 Deixe um comentário
An excellent text, recommend everyone to a better understanding of processes in mySQL.
In an earlier post (Scripting Backups of MySQL with Perl via mysqldump), I showed you how to use Perl to script a mysqldump backup of selected databases. Reminder – using mysqldump to backup your databases is not as safe or effective as using MySQL Enterprise Backup.
A blog reader sent me an email asking me how they could automate sending the backup files via FTP to another server (preferably one that is off-site). This was easily accomplished by adding a series of FTP commands to the original script.
As in the first post, we use a text file that contains a list of the databases that we want to backup. See this post for more information on using the script to backup your files – I don’t want to duplicate the entire post here.
For the FTP part of this script, you will need to edit the…
Ver o post original 1.158 mais palavras