View source

<seo title="How to restore MySQL database" metakeywords="sql database,restore MySQL database,MySQL database,restore database" metadescription="How to restore MySQL database in cPanel" />

<div align=justify>In some cases the changes you make to your site may corrupt it and you may want to restore the site to its previous state. If your site is database driven then you'll need to restore the MySQL database.
This tutorial will provide you with the steps needed to restore MySQL databases.

'''1'''. First of all, '''login to your control panel''' at ''www.yourdomain.com/cpanel''

'''2'''. Click on '''Backups''' under the '''Files''' section.

'''3'''. Click '''Browse''' to locate the Database you want to restore, then click '''Upload'''

 {{#icon: Restore MySQL database.png|Restore MySQL database}}

It may take a while to upload your .sql file and populate the database so a broadband connection would help. 

'''Note: This will overwrite the current database'''

It is recommended to periodically make backups of your site and databases, so in case of data loss you can restore the MySQL database without any difficulties.

Also see how to create a database backup '''[http://myidealhost.com/tutorials/SQL_backup here]'''</div>

Return to How to restore MySQL database.

Retrieved from "http://myidealhost.com/tutorials/How_to_restore_MySQL_database"

Navigation

Search