How to copy a database table with phpMyAdmin

 

Copy a database table : Several times, we need to copy SQL Server table schema and data from one database to another database.

We assumed that you have already logged in into cPanel.

Or click here to see how to login to cPanel.

 

Steps (Copy a database table):-

  • Click phpMyAdmin icon.
  • Click on the database table that you want to copy it.
  • Then click operation tab.
  • Scroll down little bit and find “copy table to” section.
  • Enter the new name for the table under this section and click go.

That’s it. You have created a copy of database table.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to delete fields from database tables with phpMyAdmin

  Delete Fields: Deleting a field from the form builder also permanently deletes the data...

How to insert fields into database tables with phpMyAdmin

  Insert Fields: To store a new piece of data about something for which you already have a...

How to rename database tables with phpMyAdmin

  Rename Fields: Sometimes we need to rename the existing database tables. We assumed that...

How to modify fields in database tables with phpMyAdmin

  Modify Fields: To make changes in the existing fields we use the modify options. We assumed...

How to run SQL queries on a database with phpMyAdmin

SQL queries: SQL stands for Structured Query Language. SQL is used to communicate with a...