AOMEI Cyber Backup
How to MySQL Remote Backup [Detailed Steps]
MySQL Remote Backup is a way to protect your database from disasters, etc. By storing your database backups on either a remote server or cloud storage, you can ensure the security, availability, and recoverability of your data.
By Amelia / Updated on March 5, 2025
Databases are an important backbone for businesses, and backing up this important data is critical for disaster recovery, data security, and business continuity. MySQL remote backup is an effective backup method that can store a copy of the MySQL database on a remote server or cloud storage to ensure data loss.
Why Use Remote MySQL Database Backup
1. Protection against hardware failure
If a server’s hard drive fails, local backups may be lost. Remote backups provide an extra layer of security.
Some disasters can damage local hardware. Remote storage ensures that data remains accessible.
3. Protection against cyber threats
Ransomware attacks can encrypt or delete local data. Remote backups can reduce risks.
4. Data availability
Storing backups remotely enables access from anywhere, making it easy to restore your database when needed.
Methods of MySQL Remote Backup
The following provides you with several methods for remote MySQL database backup.
Methods 1. Remote Backup using mysqldump
The mysqldump command is a simpler way to create a remote backup of MySQL. It generates an SQL file containing the command to recreate the database.
- Connect to the remote server via SSH.
- Run the mysqldump command:
- Transfer files to a remote server using SCP or FTP:
Method 2. Automate Backups using Cron Jobs
To automate this process, install a cron job on the Linux server:
/backups/db_backup_$(date +\%F).sql.gz && scp /backups/db_backup_$(date +\%F).sql.gz
user@remote-server:/backup-location/
📌Tip: This script runs every day at 2 AM, compresses the backup, and transfers it to the remote server.
Methods 3. Continuous Backup using MySQL replication
MySQL replication allows real-time data synchronization between a primary and a secondary (remote) server. If the primary server fails, the secondary server can take over.
- Configure the primary server to allow replication.
- Set up a secondary server with a replicated copy of the database.
- Monitor and maintain replication health.
Methods 4. Cloud-Based Backup using Amazon S3
Cloud storage solutions can provide scalable and secure remote backup. Tools such as rclone or AWS CLI can automatically transfer to cloud storage. The following uses AWS S3 as an example:
Alternative: Using AOMEI Cyber Backup for Backup SQL Database to Remote
You can choose to use AOEMI Cyber Backup for MySQL remote backup, including your network shares and mapped drives. It is a centralized backup and management solution that can provide you with numerous options:
User-friendly Interface: It has an intuitive web console that allows users to centrally backup SQL data and easily configure SQL backups without scripting.
Comprehensive SQL Backup: It backs up Microsoft SQL databases and all objects, including configuration, schema, logging, authentication, commands, clusters, and more.
Support Multiple Backup Locations: You can save backup files to different locations, such as the local path, external hard drive, Network Share, NAS drive. It also supports backup MSSQL to AWS S3.
Auto and Schedule Backup: You can set a backup schedule to automatically run the backup task daily, weekly, and monthly.
Restore to another SQL Server: Besides restoring to the original location, you can also restore a database to another SQL Server on another client computer.
Easily MySQL remote backup via AOMEI Cyber Backup
Prerequisite
- Log into the AOMEI Cyber Backup, navigate to Source Device > Microsoft SQL > Add Microsoft SQL.
- Choose Download proxy program and install it on the device with SQL Server installed. Then click Already installed proxy and select the device to Confirm it.
- Then click … > Authentication to validate the database instance.
Step 1. Go to Backup Task > Create New Task and select the Backup Type as Microsoft SQL Backup.
- Enter a name for the backup task, then select the databases you want to backup and specify a location as a storage end.
- Specify a local path or network path as the backup Target. To back up the SQL database to a remote location, you could click Add a new network storage, then the added path will be saved in Add storage.
- You can set up a Schedule to run the SQL database backup daily/weekly/monthly and set the backup method as Full/Incremental/Differential.
Step 2. Click Start Backup to start the backup process.
Step 3. After completing the SQL Server backup, click Restore to restore a differential backup in the SQL server.
When restoring, you only need to select a differential backup file to restore, and the data can be restored to the state at the time of the selected differential backup.
😊More features you can enjoy:
- Backup Cleanup: It can help you to delete older backup versions automatically and therefore save storage space.
- Archive: It helps you save the SQL database backup files to an Amazon S3 storage.
- Email Notification: It enables you to receive email notifications when the task is abnormal or successful.
Conclusion
MySQL remote backup protects critical data, and whether it's with mysqldump, replication, a cloud-based solution, or AOMEI Cyber Backup, as provided in this article, having a reliable remote backup plan ensures data resiliency and fast recovery in the event of a failure.
