How to Use phpMyAdmin to Backup Database

In below, we have worked out a detailed tutorial show the detailed method to backup a database by using phpMyAdmin that is a popular tool based on PHP and supports many operations on MySQL. If you have a site based with shopping cart software, WordPress, Joomla or other programs, you are likely have a database. Then, you need to backup your databases to prevent data loss and many annoying things.

Before using phpMyAdmin to back up your database, you first need to log into your control panel. If you are using cPanel, you are able to enter cPanel via a direct login URL and via AMP. If you choose to log into cPanel via a direct login URL, you need to visit the URL yourdoamin.com/cpanel to get to your cPanel login first. Besides, you are allowed to log into your control panel by visiting your host’s official site and clicking Login. Then, type your cPanel username and password, and click “OK” button.

What’s more, if you want to AMP, the first step is to log into AMP. Next, click the cPanel button under your account name. Then, you will be redirected and automatically logged into cPanel. If you are using other control panels, you can log into your control panel in same way. Then, start to using phpMyAdmin to backup your database by following the steps in below.

Using phpMyAdmin to Backup Database

As soon as you have logged into your control panel, you need to go through the following steps to backup your database with phpMyAdmin.

If you’re using a barebone server, you have to download and install phpMyAdmin at http://sourceforge.net/, and follow the steps at this article to install phpMyAdmin manually. Then, following the steps as below to backup your database.

Step 1. After logging into control panel, you are able to see many icons, click “phpMyAdmin” in within “Databases” section. After this, you are able to begin back up your database.

Step 2. As you can see, there are many options under “localhost”. Click “Export” and you can export a database.

Step 3. At the left side, there is a list of database. The next step is to select the database you intend to backup. Of course, you are able to choose multiple databases at the same time. After this, click the “SQL” button.

Step 4. Under the “Options”, make sure all the options except the first one and the last one under “Structure” are checked. Usually, the three items are checked by default.

Step 5. Scroll down to the “Save as file”, and select the compression file you want to save. You are allowed to click “zipped” or “gzipped” to save file as compression file helps you control the size of your file and save storage when your database is large in size. However, if your database is small, you are able to click “None”.

Step 6.Finally, click “Go” button in the bottom right corner of this section to complete the process of backing up database using phpMyAdmin.