How To Restore Mysql Database

Once having all the files on your computer, you should make a dump of your MySQL database into your website. The process of restoring is even much easier than creation of the back up. So let’s check out on how you can restore the MySQL database
As its very important to restore if anything goes wrong in the servers as whole data is lost. If you don’t want to create / restore the back up manually then you can also raise a ticket with your hosting provider and there the system admin will create backup / restore the database on your website but this will attract some fee as the system admin will be doing this job. Also, there are monthly and yearly packages which can be selected so as to lower down the cost of taking the backup or even restoring the back up.
For restoring or importing via phpMyAdmin, you need to first choose the database you will be importing data into the same. This can be easily done from the drop-down menu which is located on the left and then you need to click on the import tab.
Now, you need to go to the option of importing an .sql file. Use the Browse button to find it on your local computer. Note that you are given the option to choose the character set of the file from the drop down-menu just below the upload box. Also, if you are not sure about the character set your database is using just leave the default one as mentioned on the cPanel page in the drop down box.
So, now in order to start the restore process, click on the Go button which is located at the bottom-right after which a notification will be displayed upon a successful database import on the screen itself.