Thursday, 10 April 2014

How to Backup and Restore your website (SMS Website)

You can easily create a backup of your Website, this can be done by utilizing the Backups functionality in the cPanel of your hosting account. If your account is not too large  in size (under 500Mb) you can perform a full account backup just with one click, else..

If the account is too large (over 500Mb), Backing up the public html files and the databases should be done individually. In this case you would need to understand what your web Website comprises of and therefore what should be backed up/restored. Sites comprise of public html files and database. You should take them all if you want to have your site precisely the way it has been before.

How to backup/restore your public html files?

To backup your public html files, you should download all the files from your public_html folder to your computer using your very popular FTP client. After that you can effortlessly upload back the public html files to your hosting account and your website will be refurbished.

Exporting MySQL : How to backup MySQL database?

You can easily create an dump file(export/backup) of a database used by your account. In order to do so you should dump file to the phpMyAdmin

The phpMyAdmin tool will be loaded. Choose the database that you would like to initiate a backup from the Database list (located in the top left corner of the sheet).

A new sheet will be loaded in phpMyAdmin showing the chosen database. In order to advance with the backup click on the export tab:

The choices that you should choose apart from the default ones are Save as file (which will save the file to your computer in an .sql format) and Add DROP TABLE (which will add the drop table functionality if the table already exist in the database backup) as shown below:

 Click on the proceed button to start the export/backup method for your database:

A download window will burst up prompting for the exact Website where you would like to save the file on your computer. It is possible that the download begins automatically. This counts on your browser.

How to restore MySQL database from your backup

To restore (import) a database via phpMyAdmin, first select the first choose the database you'll be importing the data into. This can be done from the menu on the left. After which you click the import tab:

You have the option of importing an .sql file. Choose the file from your computer.. If you are not certain about the character set your database is using just leave the default one.

In order to start the restore click on the Go button at the bottom right. you will see a notification upon a successful database import.

Thanks for going through this post. Hope that this helps. Please feel free to drop your comments and questions below, we love to hear from you.
Don't miss out of any post, Receive all the latest post/updates via Email. Enter your email below.     ...... Peace !!! .....

No comments:

Post a Comment