Support Center

How do I backup a Rackspace Cloud Sites database?

In this article, we are going to show you how to backup your Rackspace Cloud Sites database. For a video walk through, check out this tutorial video.

To backup your Rackspace Cloud Sites database, you will need the following information:

  1. MySQL Database Name
  2. MySQL Username
  3. MySQL Password
  4. Database Management IP Address

Since we will get the database management IP address, we do not need to whitelist CodeGuard's IP addresses with our Cloud Site. Now we will go through the necessary steps to get this information. There are numbers throughout the walkthrough that correspond to the necessary information above.

Step 1: Login to Rackspace Cloud Sites Control Panel

First, we need to login to the Rackspace control panel. You can get there by going to this URL: manage.rackspacecloud.com. Login using your Rackspace Cloud Sites credentials.



 

Step 2: Navigate To Your Cloud Site

Now we will need to get to our Cloud Site management panel. To do this, click the 'Hosting' button on the left side, then choose 'Cloud Sites'.


 

Select the website that has the database that you wish to backup.



 

Step 3: Navigate to Database

Now that we are on the correct Cloud Sites page, we need to get to our database. Choose the 'Features' tab.


 

Now we should select the database that we want to backup. Here we only have one database associated with the Cloud Site, so we will choose that one. Once you have copied down this database's name, click on it.



 

Step 4: Database Management IP Address

Since CodeGuard will be connecting to our database remotely, we want to copy down the Database Management IP Address. This will allow CodeGuard to successfully connect to our Cloud Site.



 

Step 5: MySQL Username and Password

Now that we have the Database Management IP Address, all we need now is to create a new MySQL username and password for our database. Scroll down on the page to see the 'Add New Database User' section. Create the new user and enter a password. Keep note of these items for adding your database to CodeGuard.


 

Step 6: Activate Database in CodeGuard

Now that we have all of the necessary information, we can login to CodeGuard to add our database. Go ahead and login to your CodeGuard account: CodeGuard Login and choose the website which your database belongs to.


 

Once we have chosen the website, click the 'Add Database' link at the bottom of the screen.


 

Now we can test the connection to make sure that CodeGuard can make a connection to our database's IP address. Here you want to enter the Database Management IP Address. After you have done that, press the 'Test Connection' button.



We will now test the connection to that IP address. You will see if the connection was successful on two of our most common IP addresses. Once you see that the connection was successful, click 'Next Step'.



The following step is just to verify that you've properly whitelisted our IP addresses. As a Rackspace customer, these IP addresses have already been whitelisted for you, so you can disregard this step. Click 'Next Step'.


 

We can now add the rest of our credentials. Once all of them have been entered, press 'Next Step'.


 

Here we will select the database name that we previously found in our Cloud Sites control panel.


 

That's it! Our database is now activated and we can follow along with the progress. CodeGuard will also send you an email once the activation is complete.


 

If you run into any issues during the activation of your website, please contact support@codeguard.com and our support team will help you get your Rackspace Cloud Sites database up and running in no time.

Contact Us