Copying a Database Table with phpMyAdmin

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

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.

Was this answer helpful? 0 Users Found This Useful (0 Votes)