To export data from MySQL database using phpMyAdmin, follow the procedure below.

1. Log-in to phpMyAdmin using your database credential.  ( Using PhpMyAdmin )
2. Select your database name from drop down menu in left frame.
3. Click on Export tab at the top on right frame.
4. Click on SELECT ALL in Export section to select all tables or select required table.
5. Select the desired export format in Export section.
6. Select check box in Structure tab section to include table structure
7. Select check box in Data tab section to include all data within table
8. Select check box in Save as file section and enter file name.
9. Click on GO