Copying tables between MySQL Databases with PHPMyAdmin
This is a quick article to show you how you can copy tables between databases that you have access to on your MySQL server by using PHPMyAdmin.
To begin this procedure, on the left hand menu that shows the list of tables in your database, click the table name that you want to copy to another database database – below is a screenshot of this list, this has the database name blanked out, but is a WordPress database
Once you have clicked the name of the table you want to copy in the left hand menu, a new page will open showing you the structure of the table, there will also be a menu bar at the top of the screen, with an option named operation. Select this option and you will be taken to the screen where we can actually do the copy. Once you have clicked the operations button you will be on a screen similar to the one below.
Once you are on the screen shown above, we can do the copy. On the pane on the right hand side you will see the option ‘Copy table to (database table)’. In the drop down list select the name of the database you want to copy the table to and then in the text box to the right hand side type the name that you want the table to be called in its new location. By default this will copy the table and all the data within the table, but if you only want to copy the structure you can use the radio button options below the drop down box to do so. Once you have selected the target database, typed the name of your target database and selected the copy options using the radio button, click go and the database table will be copied to the database you selected. You will receive a confirmation message at the top of the page when this process has completed.
You will also notice that on the same screen you can also rename the database table you selected, or move the table to a new database instead of copying it.
That’s all for now – I have also written an article explaining how to copy tables between MySQL databases via SSH.
If you have found this post helpful please consider making a donation to keep the site running.
