Back to search

Copying a database table with phpMyAdmin

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

Was this answer helpful?      

Also Read

How to install DokuWiki from Softaculous
1 Scroll down to the Wiki group. 2 Find DokuWiki in the menu. You will be taken to the...
How to install phpBB from Softaculous
This demonstration will show you how to install phpBB from Softaculous. 1 Scroll down until you...
Deleting tables from a database with phpMyAdmin
This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to delete a...
Configuring your website in WS_FTP
This tutorial assumes you already have WS_FTP running on your computer, but have not connected to...