How Do I Restore A Database Using PHPMyadmin?

Even though your managed hosting package will likely include automatic backups of your database which can then be restored in an emergency, you may find it necessary to restore a backup of your database manually at some point in time. It is always good policy to have a database management plan that includes knowing how to restore a database if needed, and restoring a database can be easily achieved using PHPMyadmin.

 

  • Logon to your account and in Cpanel find and open PHPMyadmin.
  • In the left-hand column choose the database you want to restore.
  • On the page that opens you will see a list of all the tables in that database. Look at the end of the tables column and click "Check All", or manually select the specific tables you want to restore if only a partial restoration of the database is needed.
  • Next to the "Check All/Uncheck All/Check tables having overhead" is a menu box. Click the down arrow and select "Drop" among the menu options.
  • You will immediately be presented with a prompt asking if you really want to drop (delete) the tables you have selected.
  • Click the Yes button.
  • Click the Go button. The tables you selected will be deleted.
  • Click the Import tab
  • Click the Browse button and find your saved database backup file to be restored.
  • Click the Go button and the backup file will be uploaded and the SQL commands executed and your database will be re-created using the backup files.
  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

What is Cpanel

Web hosting can be a scary world. Dealing with all of the ins and outs of website design is...

How to Use Your Dedicated Server to Send Emails.

When setup correctly, a dedicated server can be used for all email hosting needs - both to send...

How Can I Backup A Database Using PHPMyadmin?

Most managed hosting accounts include automatic backup of files and databases, but it is good...

How Do I Access Cpanel?

Accessing the cPanel front end within your dedicated hosting plan for utilising managed hosting...

How Do I Backup My Entire Site in cPanel?

It is very important to always make sure all files and databases stored on a dedicated server...