Disabling AUTOCOMMIT, UNIQUE_CHECKS, and FOREIGN_KEY_CHECKS speeds up mysql restores dramatically. My own tests of a 30MB dump were cut from 6 minutes to 11 seconds. My 2GB backups can now be imported in a reasonable 40 minutes. The following script will add one line to the top and bottom of your mysqldump file. This can take a while for large files. There’s no shortcut…
Tag: Script
Simple Duplicity S3 Script
Duplicity is a command line tool that performs encrypted incremental backups. It supports a variety of file locations, including Amazon S3, and comes pre-installed on several Linux distributions. Ubuntu’s backup application, Deja Dup, is a frontend for Duplicity that adds some convenient right-click functionality to the file explorer. This works well on the home directory to quickly restore previous versions…
Matt Williamson 