VPS & 전용 서버(내 서버) 도움말

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 your server or shared hosting account with SSH
  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


이 글이 도움되었나요?
피드백을 보내주셔서 감사합니다. 고객 서비스 담당자에게 문의하시려면 지원 전화 번호 또는 위의 채팅 옵션을 이용하시기 바랍니다.
도와드릴 수 있어 기쁩니다! 더 도와 드릴 것이 있나요?
그것 유감스럽습니다. 혼동이 되었던 사항 또는 솔루션이 고객님의 문제를 해결하지 못했던 원인을 알려주세요.