phpMyAdmin: Copying a database table

Let’s learn how to copy a database table with below mention steps

 

1) Click the database table you wish to copy.

2) Then click the Operations button.

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, then click Go.

 3) 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

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

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...

How do I check the size of my database?

Using the below mentioned steps, we will show you how to check the size of your database so you...

I need a different version of PHP/MySQL

If for some reason you cannot install programs on your server like Joomla, Drupal, WordPress,...

How do I optimze mysql in Cpanel?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How do I optimze mysql in plesk ?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...