Copying a database table with phpMyAdmin

phpMyAdmin lets you copy any database table quickly, giving you the choice to copy the table structure, its data, or both.

How to copy a database table

1. Open phpMyAdmin and click the table you want to copy in the left-hand panel.

2. Click the Operations tab along the top of the page.

3. Scroll down to the Copy table to (database.table) section and choose what to copy:

   • Structure only - copies the table layout with no rows
   • Data only - copies the rows without recreating the table definition
   • Structure and data - creates a complete duplicate

   Enter a name for the new table, then click Go.

   

4. phpMyAdmin confirms the operation and the new table appears alongside the original in the left-hand panel.