phpMyAdmin: Copying a database table

Let’s learn how to copy a database table with below mention steps

 1) Click the database table you wish to copy

 2) Then click the Operations button.

      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, then click Go.

 3) 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

 That’s it! A new table has been created, and it is a perfect copy of the original. Both tables are now listed here

 This is the end of the Article. You now know how to create a copy of a database table using phpMyAdmin

  • PhpMyAdmin, copying, table
  • 128 Users Found This Useful
Was this answer helpful?

Related Articles

What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such...

How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql'Then scroll down to the 'access hosts'...

How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...