Need help?
08456 171 171
Online Support Web Hosting

How to backup a database with phpMyAdmin

Regularly creating backups of your website files is highly recommended. This is so when something unfortunate happens to your site, you will always have the option to restore your website files to previously working versions.

To create backup copies of your website files, you can use the Backup, Backup Wizard, or phpMyAdmin features in the Hosting Manager.

If you want to know how to get backups of your website files with Backup or Backup Wizard features, click the links below:

To create backup files using the phpMyAdmin feature, follow the steps below:

  1. Click on My Account at the top of the page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Databases or the [ v ] arrow symbol on the right side.
  5. Next, click the phpMyAdmin button, which is next to MySQL Databases icon.
  6. At the next page, you will get the following notification:
    The system will redirect you in a moment.
    This will only last for a few seconds, and then you will be redirected to the phpMyAdmin control panel.
    At the main phpMyAdmin page, on the left side you will find a menu tree or navigation panel. Find your hosting username and click the [+] plus sign beside it to access the drop-down menu. This will give you a list of your databases.
  7. Find the database you want to create a backup copy of, and click it. This will open the database table.
  8. Select the tables you want to download, or go to the bottom of the table and click Check All to select the entire database.
  9. Then on the top menu bar, click Export.
  10. Next page, under Export Method, select how you want your backup file to be downloaded. Choose the Quick option if you are sure you have selected all the tables you want to create backup copies of.
  11. Make sure to choose the SQL format in the Format field.
  12. Click Go.

The database backup will then be automatically saved on your computer. The backup file will have the .sql file extension.

If you want to remove or add some tables, you can do the following instead:

  1. Under the Export Method, choose the Custom option if you want to remove or add some tables.
  2. Under the Save output to a file in the Output section, select your choices for the following fields:
  3. File name template This will set the name of the backup file you will create and download.

    Default value is @DATABASE@, which will become hostingusername_database when downloaded.

    You can also choose to type any name, without the (@) at symbol in the field instead.
    Character set of the file This is the character setting of the file that you are going to download. The default value utf-8 is the most commonly used character setting on the internet today.
    Compression This will set what type of compressed file your backup copy will be.
  4. Make sure to choose the SQL format in the Format field.
  5. Below the Format field are further options you can also choose to set. By default, though, the blanks and checked options under Format-specific options are already set for a basic backup file creation.
  6. Click Go.

The database backup will then be automatically saved on your computer. The backup file will have the .sql file extension.

Congratulations, you now know how to backup a database with phpMyAdmin.

If you want to know how to access phpMyAdmin, click here.

If you want to know how to restore a database backup with phpMyAdmin, click here.

Was this helpful? Yes No 73% of people found this helpful.
we're
online
Need Help? Chat Now