In the following article, we will show you how to backup your database by using SSH Tunneling on a WebHostingBuzz shared hosting account.
Step 1: Credentials
You will need to collect the following information to add your database through SSH tunneling:
First, we need the login details for our cPanel administrative portal. If you don't already know them, they should have been sent to you in an email when you signed up for a WebHostingBuzz account.
Step 2: Enable SSH
Now that we have our credentials, we need to make sure that SSH is enabled for our account. In order to do that, you will need to send an email to 'email@example.com'. Below is a template you can use to ask to enable your SSH:
I would like SSH access enabled for my account, please.
My website URL is [your domain name] and my cPanel username is [your cPanel login].
Will my SSH username and password be the same as my cPanel login?
Also, will the SSH port be the default 22 or is it configured to be a different port?
I received the following email in return:
As you can see, SSH is currently enabled and I can use my cPanel username/password to log in. Also, the port to use for SSH is 65321.
Step 3: Ensure SSH is Enabled
Now we need to make sure that SSH is enabled. Login to cPanel which you can get to with the following link: yourdomainname.com:2083.
Once we are in cPanel, we need to get to the SSH Access page. Search for 'Shell' in the left-hand search bar and click on SSH/Shell Access:
Now that we are in the SSH/Shell Access tab, we can verify that SSH is enabled. Check to make sure you see the 'Java SSH Login' section. If you do not, please repeat step 2 and make sure WebHostingBuzz enabled your SSH access.
Step 4: MySQL Credentials
Now that SSH is definitely enabled, we need our MySQL credentials. Go back to the main cPanel page and search for 'mysql'. Choose the 'MySQL Databases' tab.
We can now get our MySQL database names and users. If you do not know your MySQL user password, we can create a new user for CodeGuard. If you already know your user's password, please skip ahead to step 6.
Step 5: Create New MySQL User (If Necessary)
To create a new MySQL user, scroll down on the MySQL page and add a new user with a password that you can write down and remember:
You will be taken to this page, where you can choose the privileges for the user:
Finally, select your new user from the drop-down menu, select the database you wish to add it to, and click 'Add'.
Step 6: Activate Database in CodeGuard
Now that we have all of our necessary information, we can add the database in CodeGuard. Login to your CodeGuard account, go to the website that you wish to add the database to, and select 'Add Database' at the bottom of the page.
Since WebHostingBuzz blocks remote connections by default, we won't be able to test our connection on this page. If you've already added databases, you will be able to choose 'Skip This Step' to get to the credentials page. Otherwise, enter your database hostname or IP address and click 'Test Connection'.
Now that we are on the credentials page, we can enter all of the information that we got earlier in this walkthrough. Choose 'Tunnel over SSH' and remember to change your port to 65321.
Upon a successful connection, you will be taken to the next step where you can select the database that you would like to backup.
That's it! Now you will be able to follow along with your database's activation progress. CodeGuard will also send you an email once it is finished so you can leave the page.
If you run into any issues when trying to backup your database with tunneling over SSH, please contact our support team.