Copying a Database Table with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's learn how to copy a database table.
  3. Click the database table you wish to copy.

    phpma-copy-frame3_1

  4. Then click the Operations tab.

    phpma-copy-frame4_1

  5. 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

  6. 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.
  7. 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

 

Be Sociable, Share!

Published by

Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support