Copying a database table with phpMyAdmin Print

  • 1

How to copy a database table using phpMyAdmin:

Step 1: Log in to phpMyAdmin
Assuming you're already logged into phpMyAdmin, you'll see a two-part interface. The left side displays your databases and their tables, while the right side is where you'll perform actions.

Step 2: Select the Database Table to Copy
Click on the database table you want to copy, which will display its details on the right-hand screen.

Step 3: Access the Operations Menu
At the top of the right-hand screen, click on the "Operations" button. This will take you to a page with various operations you can perform on the table.

Step 4: Choose Copy Table Option
Scroll down this page, and you'll find a section titled "Copy table to (database.table)." Here, you have three options for copying:
- Copy the table structure only
- Copy the data only
- Copy both the table structure and data

Select the option that suits your needs.

Step 5: Define a New Name for the Copied Table
Copying a table creates a new table that is identical to the original. In this step, you need to provide a name for the new table. Enter your desired name in the provided field.

Step 6: Initiate the Copy
Once you've entered the new table name, click the "Go" button.

Step 7: Confirmation
A new screen will appear on the right-hand side, confirming that the copy was successful. It will display the name of the copied table. You will now see the copied table in the left-hand window, listed under the database, with the new name.

 


Was this answer helpful?

« Back