Exporting databases and tables with phpMyAdmin
Log in to phpMyAdmin
• Click on the database you want to export.
• Click on export button. Click on the entire database in any format and import it later.
• Check the options you require, before proceeding. You can also check the button for saving the file.
• For exporting some table and not the whole database, follow the procedure of selection of fields. Click on Save to Disk option.