phpMyAdmin Duplicate Table phpMyAdmin Duplicate Table database database

phpMyAdmin Duplicate Table


Yes, you can navigate to the table you want and then go to (tab) Operations > Copy table to (database.table):, which is a box on the right hand side. There you can define into which database and under what name you'd like to copy your table. After having done than you get the SQL "spat out".

As I'm not completely sure about your question, if you'd like to have the table in a dump file, you could alternatively click the tab Export, where you can get the SQL as well, or download the dump file straight away.


You can use the Export tab to select which table to export. In the diagram below,

  • the album table is specified
  • Structure is checked
  • Data is unchecked - to not generate data with the export
  • SQL radio button is checked
  • ...
  • Click on the Go button at the bottom to have the generated SQL

enter image description here