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

Renaming database tables with phpMyAdmin

Renaming database tables with phpMyAdmin This video assumes you've already logged in to...

Deleting a table from a database with phpMyAdmin

Deleting a table from a database with phpMyAdmin This video assumes you've already logged in to...

Exporting databases and tables with phpMyAdmin

Exporting databases and tables with phpMyAdmin This video assumes you've already logged in to...

Importing databases and tables with phpMyAdmin

Importing databases and tables with phpMyAdmin This video assumes you've already logged in to...

Running SQL queries on a database with phpMyAdmin

Running SQL queries on a database with phpMyAdmin This video assumes you've already logged in to...

Powered by WHMCompleteSolution