phpMyAdmin - Export/Import Table as SQL

Export the Table

1. Login to your phpMyAdmin.
2. Select the database on the left hand menu.
3. Select the table you want to export.
4. Click the Export link on top.
   
5. Selections will be ticked by default. Leave it as is unless you want to change them. Then click the Go button.
   
6. Save the file to desired location.
   
   

Import the Table

1. Select the database on the left hand menu.
2. Select the table where you want to import data into.
   Note: If you have existing rows on that table you selected, make sure that they are not on your exported SQL file. If it's on the exported file, you may want to delete that row on this table to avoid duplication error.
3. Click on the Import link.
4. Browse the exported SQL file, then click the Go button.