Backup

MySQL

Auto MySQL Backup

• Login to server via SSH and change user to root

sudo -i

• Download the AutoMySQL backup tar file.

wget https://swkls.org/tmp/automysqlbackup-v3.0_rc6.tar.gz

• Create a directory in /opt and extract the downloaded file.

mkdir /opt/automysqlbackup
mv automysqlbackup-v3.0_rc6.tar.gz /opt/automysqlbackup/
cd /opt/automysqlbackup
tar -zxvf automysqlbackup-v3.0_rc6.tar.gz

After the extraction install the AutoMySQL backup ./install.sh You can use the default path for the global configuration directory and the directory for the executable. You only need to press the “Enter” key when the paths are required.

After the installation, you have to configure AutoMySQL backup. Open the configuration file with your favorite text editor. vi /etc/automysqlbackup/automysqlbackup.conf

Uncomment and set the following configuration directives: CONFIG_mysql_dump_username='root' CONFIG_mysql_dump_password='YourPassword' CONFIG_mysql_dump_host='localhost' CONFIG_backup_dir='/var/backup/db' CONFIG_do_monthly="01" CONFIG_do_weekly="5" CONFIG_rotation_daily=6 CONFIG_rotation_weekly=35 CONFIG_rotation_monthly=150 CONFIG_mysql_dump_port=3306 CONFIG_mysql_dump_use_separate_dirs='yes' CONFIG_mysql_dump_compression='gzip' CONFIG_db_exclude=( 'information_schema' 'performance_schema' ) You can configure the AutoMySQL backup by changing the values according to your needs.

Create a directory for the MySQL backups. In the configuration we have mentioned the directory /backup/db. mkdir /var/backup mkdir /var/backup/db To run the AutoMySQL backup execute the following command. /usr/local/bin/automysqlbackup If you want you can schedule the AutoMySQL backups to run on a specific time by creating a cronjob. crontab -e

Add Line: 0 2 * * * /usr/local/bin/automysqlbackup /etc/automysqlbackup/automysqlbackup.conf Here the backup is scheduled at 2 AM.

Synology Basic NAS Setup create shared folder 'backups', no recycle bin if used for staff backups create user 'backupuser' create 'staff' group give 'staff' group rw to 'backups' folder, add 'backupuser' to 'staff' group set notifications swkls+synologynas@mycheckcentral.cc mail.checkcentral.cc 587 install 'Cloud Sync' and 'Storage Analyzer' packages enable power-on after power failure & WOL enable basic SSH Email Alerts swkls+synologynas@mycheckcentral.cc

mail.checkcentral.cc

587