Knowledge Base

How do I back up a Liquid Web Cloud Sites database?

 

Overview

By the end of this article, you will have your Liquid Web Cloud Sites database backed up by activating it in CodeGuard. To do this, you will gather four pieces of information from the Liquid Web Cloud Sites control panel — your MySQL database name, MySQL username, MySQL password, and Database Management IP address — and then use them to add the database in CodeGuard. Because you will collect the Database Management IP address yourself, you do not need to whitelist CodeGuard's IP addresses with your Cloud Site.

Before you begin

Gather the following four items from the Liquid Web Cloud Sites control panel. In the screenshots, each item is marked with a matching number (1 to 4): 

  • MySQL database name

  • MySQL username

  • MySQL password

  • Database Management IP address

Step 1 — Log in to the Liquid Web Cloud Sites control panel

Go to manage.liquidweb.com and log in with your Liquid Web Cloud Sites credentials.

Liquid Web Cloud Sites login pageLiquid Web Cloud Sites login page 

Figure 1: Liquid Web Cloud Sites control panel login page.

Step 2 — Open your database in Cloud Sites

Click the web address of the website that the database belongs to. Click the Databases dropdown, then select the database you want to back up. Copy down the database name, then click the database to open it.

Cloud Sites Websites list with the target website highlightedCloud Sites Websites list with the target website highlighted

Website details page with the Databases section expandedWebsite details page with the Databases section expanded 

Cloud Sites Databases list with the database name markedCloud Sites Databases list with the database name marked 

Figure 2: Database selection screen showing the database name.

Step 3 — Copy the Database Management IP address

CodeGuard connects to your database remotely, so copy down the Database Management IP address shown for the database. This is the address CodeGuard uses to connect to your Cloud Site.

Database Information page with the Management IP markedDatabase Information page with the Management IP marked

Figure 3: Database Management IP address displayed in Cloud Sites.

Step 4 — Create a MySQL username and password

Create a new MySQL user for the database. Click Create User, enter a username and password, and save the user. Keep a note of the username and password, because you will enter them in CodeGuard.

Create Database User dialog with username and password fieldsCreate Database User dialog with username and password fields 

Figure 4: Create User option for adding a MySQL username and password.

Step 5 — Add the database in CodeGuard

Add the database in CodeGuard using the information you gathered:

  1. Log in to your CodeGuard account and choose the website that the database belongs to.

CodeGuard My Sites dashboard with the website selectedCodeGuard My Sites dashboard with the website selected

Figure 5: CodeGuard website dashboard with the database backup option.

  1. Click the Add Database link at the bottom of the screen.

CodeGuard File Backup Summary with the Add Database buttonCodeGuard File Backup Summary with the Add Database button 

Figure 6: Add Database link in CodeGuard.

  1. Enter the Database Management IP address, then click Test ConnectionCodeGuard tests the connection from two of its most common IP addresses. When the test succeeds, click Next Step.

CodeGuard Test Connection screenCodeGuard Test Connection screen 

CodeGuard Check Firewalls screenCodeGuard Check Firewalls screen

Figure 7: Test Connection step using the Database Management IP address.

  1. CodeGuard shows the IP addresses it connects fromAs a Liquid Web customer, these addresses are already whitelisted for you, so you can skip this verification step. Click Next Step. 

CodeGuard Whitelist IP Addresses screenCodeGuard Whitelist IP Addresses screen 

Figure 8: CodeGuard IP address verification step.

  1. Enter your MySQL username and password, then click Next Step.

CodeGuard Add Credentials screenCodeGuard Add Credentials screen 

Figure 9: MySQL username and password entry screen.

  1. Select the database name you copied in Step 2, then click Add Databases.

CodeGuard Select Databases screenCodeGuard Select Databases screen

Figure 10: Database selection step before adding the database to CodeGuard.

  1. CodeGuard activates the database and shows the backup progress. You will also receive an email when the activation is complete.

CodeGuard backup progress trackerCodeGuard backup progress tracker

Figure 11: Database activation and backup progress screen in CodeGuard.

Similar questions

  • How do I add a Liquid Web Cloud Sites database to CodeGuard?

  • How do I find my Database Management IP address in Liquid Web Cloud Sites?

  • How do I create a MySQL user for CodeGuard in Liquid Web Cloud Sites?

  • Do I need to whitelist CodeGuard's IP addresses for a Liquid Web Cloud Site?

Related articles

  •  

Need assistance?

Contact our team for help with your purchase or issuing your certificate.

Live chat

Call us today