Copying a Database Table with phpMyAdmin

To copy a database table in phpMyAdmin, first login to phpMyAdmin and then follow this guide.

1. In the left hand side, click the database table you wish to copy, then click the 'Operations' button.

Note: When copying a table, you have the option to copy the table structure only, the data or both.

2. Enter a name for the copy, as copying actually creates a new table.

3. Select the option for table structure, data or both and click 'Go'

4. The new table will appear on the left  and will be an exact copy of the original with a new name.

Note: For further help with phpMyAdmin click the 'Question Mark' icon on the left hand side.

Note: For further help with SQL click the 'SQL' icon on the left hand side.

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Modifying Fields in Database Tables with phpMyAdmin

To modify fields in database tables in phpMyAdmin, first login to phpMyAdmin and then follow this...

Importing Databases and Tables with phpMyAdmin

To import databases and tables in phpMyAdmin, first login to phpMyAdmin and then follow this...

Renaming Database Tables with phpMyAdmin

To rename database tables in phpMyAdmin, first login to phpMyAdmin and then follow this guide. 1....

Running SQL Queries on a Database with phpMyAdmin

To run SQL queries on a database in phpMyAdmin, first login to phpMyAdmin and then follow this...

Searching through a Database with phpMyAdmin

To search through a database in phpMyAdmin, first login to phpMyAdmin and then follow this...