How to take and restore database backups

Creating Backups

It is HIGHLY recommended that you take backups of your database at least once per month in the event you need to restore data contained in the backup.

Assuming you have accessed phpMyAdmin and are on the database you want to backup...

  • Click Export at the top
  • Check the box next to Save as File
  • Type in a filename for the backup such as the database name and date
  • Next to Compression choose Zipped
  • Click Go

You should then be prompted to save a file as a download, this is your database backup, click OK or Accept and save it to your computer.

Restoring Backups

Taking a backup is important because at some point you will need to restore from one be it bad updates of your script or otherwise.

Assuming you have your backup file and are in the database you have accessed the database you need to restore your backup into...

  • Click Import at the top
  • Click Choose.. and find the backup file on your computer
  • Click Go

You should now be in the process of restoring your backup, keep in mind the more data involved, the longer the process takes.