Copying a Database Table with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

1. Select the Database Table you wish to copy

2. Click the Operations button

Copy a Database Table - phpMyAdmin - Operations

3. When copying a table, you can choose to copy the table structure only, the data only, or both.

4. Enter a Name for the new table here, then click Go

Copy a Database Table - phpMyAdmin - Database Name

5. Copying a table creates an identical new one and requires a new Name

That’s it! A new table has been created, and it is a perfect copy of the original. Both tables are now listed here

Copy a Database Table - phpMyAdmin - Table Details Copied

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

What Our Customers say..