Sign Up / Log In
Need help?
08456 171 171
Online Support Web Hosting

How to restore a database backup with phpMyAdmin

How to create database backup files

If your website or database gets infected with a virus, hacked, or simply has corrupted files, you need to have the option to restore it to a previously working version. This is why you should regularly create backup files of your databases.

To know how to create and download backup copies of your website, click the links below:

You can also get a database backup file via phpMyAdmin. To know how, click the link below:

Note that the backup file will have the .sql file extension.

How to restore a database backup with phpMyAdmin

After creating and downloading the database backup files, you will be able to restore them to previous versions within your Hosting Manager using the following features:

  • MySQL Databases
  • MySQL Database Wizard
  • phpMyAdmin features

If you want to know how to restore MySQL databases, click the link below:

If you want to know how to restore a database backup with phpMyAdmin, follow the steps below:

  1. Click Sign Up / Log In at the top of this 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 restore to a previous version, and click it. This will open the database table.
  8. On the top menu bar, click Import.
  9. Next page, under File to Import, click Choose File and locate the database backup file you want to use.

    Note: Unless your database has a specifically different character set, don’t replace the default utf-8.

  10. Click Go.
  11. On the next page, if the process is successful, you will get the following notification:
    √ Import has been successfully finished, (number of) queries executed. (table_name.sql)

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

Was this helpful? Yes No 100% of people found this helpful.
Need Help? Chat Now