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.
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.
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.
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.
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:
-
Log in to your CodeGuard account and choose the website that the database belongs to.
Figure 5: CodeGuard website dashboard with the database backup option.
-
Click the Add Database link at the bottom of the screen.
Figure 6: Add Database link in CodeGuard.
-
Enter the Database Management IP address, then click Test Connection. CodeGuard tests the connection from two of its most common IP addresses. When the test succeeds, click Next Step.
Figure 7: Test Connection step using the Database Management IP address.
-
CodeGuard shows the IP addresses it connects from. As a Liquid Web customer, these addresses are already whitelisted for you, so you can skip this verification step. Click Next Step.
Figure 8: CodeGuard IP address verification step.
-
Enter your MySQL username and password, then click Next Step.
Figure 9: MySQL username and password entry screen.
-
Select the database name you copied in Step 2, then click Add Databases.
Figure 10: Database selection step before adding the database to CodeGuard.
-
CodeGuard activates the database and shows the backup progress. You will also receive an email when the activation is complete.
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.