m |
m |
||
| Line 1: | Line 1: | ||
| + | <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. | <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. | + | This tutorial will provide you with the steps needed to restore MySQL databases over cPanel of your [http://myidealhost.com/hosting.shtml web hosting account] provided by MyIdealHost. |
| − | '''1'''. First of all, | + | '''1'''. First of all, '''login to your control panel''' at ''www.yourdomain.com/cpanel'' |
'''2'''. Click on '''Backups''' under the '''Files''' section. | '''2'''. Click on '''Backups''' under the '''Files''' section. | ||
| Line 16: | Line 18: | ||
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. | 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> | + | Also see how to create a database backup '''[http://myidealhost.com/tutorials/SQL_backup here]'''</div> |
.jpg)
