A Web.com Partner

Copy a database table with phpMyAdmin

This tutorial will show you how to copy a database table with phpMyAdmin

Click the database table you wish to copy

frame3_17

Then click the Operations button

frame4_19

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

frame4_110

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

frame6_17

 

This is the end of the tutorial. You now know how to create a copy of a database table using phpMyAdmin

x