Database Backup

Here you can backup your database, which is highly recommended in the event of a server crash. You should not totally rely on the backup option here, so maybe a backup from within your MySQL management software is also a good idea.

If you choose this option the 'Save As' dialogue is envoked asking you to save the file somewhere safe. Removeable media such as a flash drive is recommended.

For large databases you should select the compression option to make the file size smaller. Compression is via GZip.

Restoring your database is fairly easy. You just need to navigate to your MySQL management software and run the backup SQL schematic. Most servers have PHPMyAdmin or Adminer installed. Alternatively you can use other good database software. Below are some example:

HeidiSQL (Portable SQL management. Recommended for Windows)
Adminer (Web based MySQL management in a single PHP file. No longer maintained)
AdminerEvo (Fork of Adminer)
PHPMyAdmin (Installed on many servers as the default database software. PHP based)
MySQL Workbench (Alternative Windows based software from the MySQL creators)
Database Beaver(Free database management software for Windows)