How to copy a MySQL table with phpMyAdmin?

This article will cover an easy step-by-step procedure on how to copy a table with phpMyAdmin located within the cPanel control panel.

Perform the following steps to do so :

1) Log into your cPanel account.

2) Scroll down to Databases and click on phpMyAdmin.

3) Select the Database and table that you wish to copy.

4) Go to the Operations section.

5) Locate box named ‘Copy table to (database, table).’

6) Select either option from ‘create a copy of the table’ to the current database (usually it is selected by default) OR ‘copy the table to a different database’.

7) Choose your database name from the drop-down box option and the name of the table to copy the structure and/or data into.

Choose from the following options before moving forward :

(i) Structure only :

This option creates a copy of the table and its name. Note that the option doesn’t copy data.

(ii) Structure and data :

This option allows you to copy the table along with its name, and also copies the data that it contains to the destination you choose further in the process i.e. INSERT INTO >> SELECT * FROM …..

(iii) Data only :

By clicking this radio button, you only would be able to copy the data to the destination.

After that, before establishing the table and transferring the data, you will be prompted to decide whether to drop the table you are copying to. Instead of using the original table, this queries the clone using the DROP TABLE IF EXISTS function. If you select the “data only copy” option, the modifications are not implemented.

Next, you have the option to duplicate the auto-increment value; however, you must ensure that this is done manually. Once the INSERT INTO query has been completed, the auto-increment value ends up being whatever it is. The CREATE TABLE syntax, which contains the auto-increment value from the original table, is activated if you check the box.

Finally, you will see an option labeled “Switch to copied table.” As the name implies, this option will move you to the duplicated database when the queries are finished. If you check it, the resultant page will display the duplicated database and table (if appropriate), otherwise it will remain as it was on the original page.

And that’s it!