This article is going to teach you how to copy a database table with phpMyAdmin. Just for the purpose of the article, we are going to assume that you are signed into phpMyAdmin already. We are going to use a database with one table for an example in this article. The phpMyAdmin page is split up into two major parts. The left blue screen is where you will see your database recorded, with any tables of that database listed beneath it. The right hand side is a huge white screen, where the actions take place.
Let's learn a way to copy a database table with phpMyAdmin. Select the database table you wish to copy by simply clicking on it. This will bring up all the table details in the right hand screen. From the menu at the top of the screen, choose and click on the Operations button. This will bring up a page of different operations you can perform on a table. If you scroll down the page, you can see a box called "Copy table to (database.table)." When you are copying a table, you can choose to copy one of three ways. You could copy the table structure only, copy the data only, or you can copy both the table structure and data. This is where you'll see your three copy selections. Pick one of the options.
Duplicating a table actually creates a new table altogether that is identical to the one that we are copying. So now we need to give a name to the new table. Type in the name for the new table in the box, in the blank field. Once you are done, just click Go.
A new screen will start up in the right hand window. It will confirm that the copy was successful, and what the name of the copy is. The copied table will now be showing in the left hand window, beneath the database, as a second table with the new name. This is the end of the article. You know the way to produce a copy of a database table using phpMyAdmin.
Let's learn a way to copy a database table with phpMyAdmin. Select the database table you wish to copy by simply clicking on it. This will bring up all the table details in the right hand screen. From the menu at the top of the screen, choose and click on the Operations button. This will bring up a page of different operations you can perform on a table. If you scroll down the page, you can see a box called "Copy table to (database.table)." When you are copying a table, you can choose to copy one of three ways. You could copy the table structure only, copy the data only, or you can copy both the table structure and data. This is where you'll see your three copy selections. Pick one of the options.
Duplicating a table actually creates a new table altogether that is identical to the one that we are copying. So now we need to give a name to the new table. Type in the name for the new table in the box, in the blank field. Once you are done, just click Go.
A new screen will start up in the right hand window. It will confirm that the copy was successful, and what the name of the copy is. The copied table will now be showing in the left hand window, beneath the database, as a second table with the new name. This is the end of the article. You know the way to produce a copy of a database table using phpMyAdmin.
