Backing up your MySQL Database via phpMyAdmin

Modified on Mon, 30 Jan 2023 at 10:01 AM

Your WordPress site needs core files (mostly .php files) and a database (.sql file) in order to function correctly. 


WordPress strongly suggests that you make a backup of your site core files and database (.sql) each time a major change is made to your site. You should always have backup copy of core files and database (sql) file stored on your local hard drive in case of WordPress failure, unintended changes or security breach of your site. 


Backing up your WordPress core files is relatively easy. Just connect to the site with an ftp program like FileZilla and download them to store in a folder on your hard drive. 


Backing up your database via phpMyAdmin is equally as simple, just follow the instructions below.


phpMyAdmin is a web based control panel for managing MySQL databases. You can access the Webhero phpMyAdmin console by logging in with your database username and password at:

https://mysql.webhero.com (or https://mysql56.webhero.com depending on the database defined in your wp-config.php file, see below)


If you do not know your database username and password, simply connect to your site via FTP and open the wp-config.php file located in the root directory of your website (usually public_html). This is the file that connects your WordPress core files to your database.


Your wp-config.php will look simlar to this:


 

Use the database username and the database password from the file to log in at https://mysql.webhero.com (or https://mysql56.webhero.com if specified in the DB_HOST section)



One you have logged in, click on databases at the top of the page. 



Then look for the database you wish to backup. There may be a list of databases but in this example there is only one. You will want to view all tables of the database, to do this, click where the red arrow indicates. 



You will now see all of your database tables. Click on "Check All" then select "Export" from the drop-down menu to the right. 




Selecting "Export" will redirect you to another page. From there, do not select anything, simply click "Go." 


Your database will be downloaded as an sql file. In this example, the file will be called "databasename_com.sql.' You'll want to save that file on your computers hard drive. If you want to import your database, you will first need to drop all the tables. Log in to phpMyAdmin at https://mysql.webhero.com and click on "Databases." 




Select the database that you want to work with by selecting it. 




Click on "Check All" then select "Drop" from the drop-down menu on the right. 


Confirm that you want to drop all of your tables. This will empty your database. Only do this if you are sure you have backed up your database. To import a database. Browse to your database by Logging in at https://mysql.webhero.com. Click on Databases and select your database name. Click on the Import button at the top of the page and use the "Choose File" button to locate your .sql file located on your computers hard drive. Once you have located the .sql file, click "Go" at the bottom of the page. 




Your backed up database (.sql) file has been imported. 





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article