How to Create a Database Backup

When to Create a Database Backup

Create a database backup before:

• Upgrading AffiliatePro or any addon.
• Running database migrations or refactoring.
• Making bulk data changes.
• Importing or mass-editing users, orders, or commissions.

Step-by-Step: Create a Database Backup

1. In the top navigation bar, click Settings.
2. In the dropdown that opens, click Add-Ons.
3. On the Add-Ons page, scroll to the System Settings section.
4. Find the Backups card and click Go to Module.
5. On the Backup Panel page, scroll down to the Backup Files table.
6. Above the table on the right side, click the green Get Backup button.
7. A spinner appears. The page reloads and creates a new MySQL backup. The file is saved as database_backup_version_X.X.X_timestamp.zip inside application/backup/mysql/.
8. After reload, the new backup is listed in the table with type MySQL.

What Gets Backed Up

The backup contains a full MySQL dump of your database (all tables, structure, and data) in a .zip file. You can download it later to keep a local copy or move it to another server.

Demo Mode

If the site is in demo mode, the Get Backup action is disabled. You will see a demo mode error message.