Copying a database table with phpMyAdmin

Back to search

This tutorial assumes you've already logged in to phpMyAdmin

Now let's learn how to copy a database table

Click the database table you wish to copy

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

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 tutorial. You now know how to create a copy of a database table using phpMyAdmin

Also Read

Configuring your website in FileZilla
This tutorial assumes you already have FileZilla running on your computer but have not connected...
Searching through a database with phpMyAdmin
This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to use the...
Can I use another language on my WordPress Blog?
Yes, there is a Language option that can be used for some of the Theme’s text that is display to...
How to change Softaculous' settings and email settings
This tutorial will show you how to change the settings in Softaculous. 1 Click the tools icon....