For purposes of this instruction,I am using phpMyAdmin version 2.5.6-rc1.
Go to phpMyAdmin in your web browser and select the database you wish to back up by clicking on the name. If you have multiple databases, you will need to select the name from the drop menu.
In the right-hand frame, you will see a row of links. Click
Now in the right-hand frame you will see three (3) areas. In the first area, called Export you select the table(s) you wish to back up by selecting them from the list. To select multiple tables, hold the Ctrl key and click the table names. To select all table, click the link.
In the second area, called SQL Options, make sure you have the following boxes checked:
Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
In the third area, check Save as file and type a name for the backup in the File name template :.
If your system supports it, you may also choose a compression type. None is selected by default.
Click and you will be prompted to save the backup on your local computer.