PhpMyAdmin is a powerful tool in manipulating MySQL databases. It was written in PHP, a lightweight programming language, which makes it fastest tool than is available nowadays for MySQL database management. It has a lot of management controls that provides programmers with great capabilities. One of those controls is the exportation of databases and tables.

Exportation of database and tables is important for programmers because it gives them the capability of having a back-up of their databases. Also, this control serves as the first step for the user to transport his or her data file from a MySQL server to another. The good thing is that phpMyAdmin has a simple and easy to understand interface, so exportation could be done without difficulty.

The tutorial below assumes that you have installed a phpMyAdmin tool and you know how to log in. Here are the steps on how to export database and tables with phpMyAdmin:

1. Log in to phpMyAdmin.

2. Click the name of the database you want to export. This name could be found at the left side panel of the page.

3. Click the “Export” link at the top of the page.

4. Navigate the page downward until you see the “SQL” with a radio button beside it which is at the “Export” frame of the page. Selecting SQL format will export the entire database.

5. Click the radio button besides “SQL” text.

6. Make sure to check or to uncheck all the options you want before proceeding.

7. For this test case, uncheck the “Add AUTO_INCREMENT value”.

8. Then check the “Creation/Update/Check Dates” option.

9. Navigate down the page until you see the “Save as file” frame.

10. Check the checkbox beside “Save as file” frame.

11. Click the “Go” button at the bottom of the frame.

12. A pop-up download box will appear. Make sure to select the “Save to Disk” option. Click the “OK” button.

That’s it! The database is now exported. If you want to export only the tables, follow the next steps.

13. Click the name of the table you want to export under the database name. These names could be found at the left side panel of the page.

14. Click the “Export” link at the top of the page.

15. Navigate the page downward until you see “Save as file” frame.

16. Check the checkbox beside “Save as file” frame.

17. Click the “Go” button at the bottom of the frame.

18. A pop-up download box will appear. Make sure to select the “Save to Disk” option. Click the “OK” button.

19. The table has been exported.

Note: exporting tables will only exports the selected table, while exporting database will exports all the tables, provided that they are all selected.

20. This is the end of the video tutorial. Now you know how to export database and tables using the phpMyAdmin.

21. Thank you for reading this demo. You can watch these steps for exportation of database and tables with phpMyAdmin at the embedded video above.