To export a backup of your MySQL database using PHPMyAdmin
follow the instructions below.
phpMyAdmin on the server follow instructions described in How do I manage my
||Select your database by clicking the
database name in the list on the left of the screen.
||Click the Export
link. This should bring up a new screen
that says View dump of database (or something similar).
||In the Export
area, click the Select All
link to choose all of the tables in your
||In the SQL options area, click the
||Click on the Save as file
option and the corresponding compression
option and then click the Go button. A
dialog box should appear prompting you to save the file