At first you need log into your phpMyAdmin:
Then in left column click on database that you want create backup:
After this click on "Export" tab and "Custom - display all possible options" radio button:
Then click on "Select All" tables and select "gzipped" compression:
Also check on "Add
DROP TABLE statement":
Thereafter scroll to Footer and click "Go":
Subsequently, you will begin downloading the database file.