Backing up your MySQL database is now easy, reliable, and secure with CodeGuard!
Find Your Database Information
You will need to find the following information:
- Database Hostname or IP
- Database Name
- MySQL Username and Password
- MySQL Port Number
Step 1: Log into your Bluehost hosting account
Click the "Advanced" tab on the left side of the screen
Step 2: Locate your hostname
The hostname will be the URL of your control panel as highlighted in the screenshot below
Step 3: Create a new MySQL user and assign it to your database
In the "Databases" section, click "MySQL Databases"
Scroll down to the "Add New User" section. Enter the username you'd like and a strong password and click "Create User".
The MySQL user that you will use to add your database is going to be the the username you created plus the prefix. In the example above, the MySQL username would be bluehqf3_cguser.
After creating your user, click "Go Back"
Next, you will need to add your user to the database. If you are adding multiple databases, you will need to do these next steps for all databases being added.
Scroll down to the section titled "Add User To Database". Select your newly created user and the database that you will be adding from the dropdown menu and click "Add".
The next step is to grant all privileges to your MySQL user. This will allow us to perform the steps needed to successfully back up and restore your databases.
When you see the success notice, click "Go Back"
You will now see that your MySQL user has been added successfully to your database. Again, if you have more than one database to add, you will need to add your user to each of them.
Step 4: Log into your CodeGuard Account
Click the Account icon and click "Products" in the dropdown menu.
Next to your CodeGuard plan name, click "Log in".
Step 5: Add your database to CodeGuard
Scroll down to the "My Sites" section of your CodeGuard dashboard and click the "Actions" dropdown next to your website and select "Add Database".
Enter your hostname that you got from the Bluehost Control Panel URL then click "Test Connection".
Next, we will check to make sure there are no firewall rules blocking our connections from some of our IP addresses. When all checks pass, click "Next Step".
You can safely skip this next step. As a Bluehost customer, our IP addresses are already whitelisted. Go ahead and click "Next Step".
Next, you'll enter your new MySQL user's username and password and click "Next Step".
Here, you'll see a list of all of the databases that you added your MySQL user to. Select the databases that you'd like to back up. If you want all of them, click "Select All". Once they are selected, click "Add Databases".
Your database backups have begun! For the initial backup, you will be shown a progress tracker. It will take you step-by-step through the database's initial backup. There is no need to sit and watch this if you don't want to. You will be notified by email when the initial backup is complete.
When the backup is complete, you will see your first backup show in your dashboard.
Congratulations! You have successfully added your databases to CodeGuard!
If you have any questions about this process, or if you run into any trouble, please contact the fantastic Bluehost support team by any of the following methods:
- Call Bluehost at 1.888.401.4678. System administrators and knowledgeable professionals are available 24×7 to answer your questions and assist you.
- Live chat with Bluehost – https://helpchat.bluehost.com/ – and their staff can assist you.