Copying a database table with phpMyAdmin



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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Becoming familiar with databases and phpMyAdmin

Becoming familiar with databases and phpMyAdminThis video assumes you've already logged...

Creating a table in a database with phpMyAdmin

Creating a table in a database with phpMyAdminThis video assumes you've already logged...

Deleting a table from a database with phpMyAdmin

Deleting a table from a database with phpMyAdminThis video assumes you've already...

Deleting fields from database tables with phpMyAdmin

Deleting fields from database tables with phpMyAdminThis video assumes you've already...

Exporting databases and tables with phpMyAdmin

Exporting databases and tables with phpMyAdminThis video assumes you've already logged...

Powered by WHMCompleteSolution