Introduction

Using a QNAP linux NAS you can backup MYSQL databases on remote servers. This article shows you how to write a script to do this. This script can then be run at set intervals using the cron scheduler to ensure your mysql data server is backed up safely.

This guide assumes your server is running the SSHD and allows you to run remote commands. For example a VPS server is the perfect example of this.

Step 1

Introduction

If you run an important server such as web server you should of course take regular off site backups. Now everyone knows that backups are a total pain to do manually and more often than not get forgotten. However, using linux cron you can automate this task easily and be more confident of your ability to recover should anything go wrong with your server and you need to restore. If you have a decent connection speed at your home or office you can program a QNAP 109 NAS (network attached storage) to take care of this important task for you.