Site Backup database backup configuration

You have to manually configure your server to let Site Backup connect to your database server. If you don't configure this, Site Backup cannot connect or back up databases on your server.

Edit my.cnf

1. Connect to my server with SSH (Secure Shell)
2. Open the /etc/my.cnf file
3. Locate the line that begins:
   bind-address=
4. Comment out this line by placing a hash (#) in front of it.
5. Restart MySQL by running the following command, depending on your operating system:

   OS	Command to restart MySQL
   Ubuntu/Debian	sudo restart mysql
   CentOS/Fedora	service mysqld restart
   Arch	/etc/rc.d/mysqld restart

Configure your control panel

If you have a Managed or Fully Managed server with cPanel or Plesk, you need to let the following IP addresses access your servers' databases:

• 52.8.12.161
• 52.8.234.204
• 52.8.41.70
• 52.8.48.18
• 52.17.127.239
• 52.17.39.62
• 54.169.144.94
• 52.74.54.75

cPanel/WHM

1. Log in to WHM.
2. On the left, in the SQL Services section, click Additional MySQL Access Hosts.
3. Enter the IP addresses listed above, and then click Save.

Note: If you want to use Site Backup with multiple cPanel sites, you can instead make this change in WHM.

Plesk

Note: These steps assume you've created a database user that accepts remote connections from any host or from the IP addresses listed above.

1. Log in to Plesk.
2. Click the Server tab.
3. In the Security section, click Firewall.
4. Click the Firewall Rules tab.
5. Click Client MySQL server.
6. Select Switch on the rule.
7. In the Remote addresses section, use the Add an IP address or a network field to Add the the IP addresses listed above.
8. Click OK.
9. Click MS SQL over TCP protocol and repeat the steps above to add the IP addresses to the firewall rule.

Next steps

• Add databases to Site Backup