Adding a database to your CodeGuard account
-
Visit the CodeGuard dashboard, as explained above in the process for adding a website. Click on the Databases tab.
-
In the next screen shown below, click the Add Database button.
-
During the initial addition of a database to CodeGuard, you can test the server connectivity by providing the database hostname or the IP address.
You can locate the IP address of the database server as mentioned below:
-
cPanel: In the cPanel control panel, look out for the IP address under the Stats section.
-
Plesk: In the Plesk control panel, click on the Databases link.
In the next screen, locate the IP address under the Database server column.
NOTEThe process of database management varies for different hosting providers. You need to consult their support team or documentation for more specific instructions.
-
-
Click on the Test Connection button.
Before you proceed, for direct MySQL connection, ensure that the IP addresses provided by CodeGuard are whitelisted in your hosting control panel.
-
You will be required to add your database details. If you have them, proceed to step 6 directly.
If the database details are not available, you can fetch them for an existing database.
This process is explained below for a couple of commonly used hosting control panels:
-
cPanel:
-
In the cPanel control panel, click the MySQL Databases link under the Databases section.
-
Under the Current Users section, click the database user link for an existing user.
-
Modify the password for the database user.
-
-
Plesk:
-
In the Plesk control panel, click the Databases link.
-
Here, you can view a list of existing databases. Click the Users tab.
-
You can now view a list of existing databases users. Click on the user link.
-
Modify the password for the database user.
-
-
-
On a successful connection, you will see the screen shown below. Enter your database details.
-
In the cPanel control panel, click the Remote MySQL link under the Databases section.
-
Add the IP addresses to the Access Hosts list individually.
If SSH has been enabled for your hosting account, you can connect to the database over SSH. Here, choose the Tunnel over SSH option.
In case of WHMCS Domains's servers, only the Connect to MySQL directly option is supported.
Click on the Next Step button to proceed.
-
-
Select the database to be added and click on the Add Databases button. CodeGuard will then start an initial backup process.
-
Once the backup process starts, you can view its progress. You will see the screen displayed below, once the backup process is completed.
MS-SQL
You can also add an MS-SQL database to CodeGuard, follow the steps mentioned below.
- If you have not yet configured a database for your website, click Databases on the navigation bar and then click Add Database.
- From your Plesk panel note the database hostname or IP address.
- Enter the database hostname or server IP address. Click Test Connection.
- CodeGuard will check for firewall access. If the connection is successful it will be highlighted in green as shown. Click Next Step.
- On the Whitelist IP Addresses page, click Next Step.
- Enter the database username and password for the database you want to connect with CodeGuard. Click Next Step to proceed.
- Note the database name from the Plesk Panel.
- Enter the database name which you want to add to CodeGuard and click Add Database.
- You will see a success screen once the database is successfully added.
If you get an error as shown please wait for sometime (5 mins approx) and then click RETRY ACTIVATION. The database should be added and the backup process should start. 
This completes the process of adding a website and a database to your CodeGuard account. CodeGuard will now regularly check your website and database and will take a backup if any changes are detected.
