Copying a Database Table with phpMyAdmin

Reading Time: < 1 minute

This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to copy a database table.

  1. Click the database table you wish to copy.phpma-copy-frame3_1
  2. Then click the Operations tab.phpma-copy-frame4_1
  3. When copying a table, you can choose to copy the table structure only, the data only, or both. Enter a name for the new table here, then click Go.phpma-copy-frame5_1
  4. Copying a table actually creates a new table altogether (that’s identical to the one we’re copying)….. so we have to give a name for the new table.
  5. That’s it! A new table has been created, and it is a perfect copy of the original. Both tables are now listed here.phpma-copy-frame6_1


Refer a friend and get a $50 hosting credit!