How to Backup your Database with phpMyAdmin

[am-fs]

From time to time we all need to make a database backup of our websites, if your moving to another hosting company or just being safe. Here is one way of making a backup.

Log on onto your hosting cpanel

Select phpMyAdmin



It should look similar to this

Select Export from the top menu.



You will now have a few options to select.
Select Custom



Select All Tables



Then select the option of Drop Table



Then hit the Go button.

Now you have a saved database backup of your website on your pc.

[am-fs]

Now I will show you How to Import your database.

Log on onto your hosting cpanel

Select phpMyAdmin



It should look similar to this



Select Import from the top menu.



Use the browse button to locate your database backup.sql file

Select the go button and your database will be imported.