METHOD 1 - phpMyAdmin

You can use phpMyAdmin to backup/restore your database if it is relatively small (~200k)
If your database is larger than that please skip to METHOD 2 - command line

BACKUP:

1) Select the database you’d like to back up from the column on the left
2) Click on “Export” from the top set of tabs
3) Select the tables from the list that you would like to backup, if you want to backup the
entire database hit “Select All”
- Select “Structure and data” from the bullet list
4) Selection boxes:
- Check the “Add ‘drop table’” box if you are moving the database to a new location and don’t