Contact Support : +64 220 256 070

Aimvm
Blog

How to backup and restore a mysql database?

Posted on: October 6, 2014

This lesson will teach you on how to generate a database backup and how to restore it.

Backup:

1) Open your cPanel and go to ‘PHPmyadmin’.

1d

2) Select the database you want to backup.

2d

3) After selecting click on the ‘Export’ option

4d

4) Click on the ‘go’ button and a backup for the selected database will be downloaded to your local machine.  Please select the .sql format every time when you are downloading.

Restore:

1) Open your cPanel and go to ‘PHPmyadmin’

1d

2) Select the database on which you want to restore the backup.

2d

3) Click on the ‘import’ option

5d

Here you can select the backup file from the local computer and click on ‘restore’.

 

Now you have restored the backup successfully.

If you find any difficulties in backing up or restoring the databases, feel free to open a support ticket with us.

 

 

Search Blog