Copying a database table with phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

Now let’s learn how to copy a database table.

First, select the database where the table exists…

… then click the table you want to copy.

Click the Operations tab.

When copying a table, you can choose to copy the table structure only, the data only, or both.

Copying a table actually creates a new table altogether, so we have to give a name for the new table.

When ready, click Go.

That’s it! A new table has been created, and is a perfect copy of the original. Both table sare listed in the left pane.

This is the end of the tutorial. You now know how to copy a database table with phpMyAdmin.