Copying a database table with phpMyAdmin

Copying a database table with phpMyAdmin


This tutorial is going to teach you how to copy a database table with phpMyAdmin. For the purposes of the tutorial, we will assume that you are logged into phpMyAdmin already. We are going to use a database with one table for an example in this tutorial. The phpMyAdmin page is divided into two main parts. The left blue screen is where you will find your database listed, with any tables of that database listed below it. The right hand side is a large white screen, where the actions take place.

Let's learn how to copy a database table with phpMyAdmin. Select the database table you wish to copy by clicking on it. This will bring up all the table details in the right hand screen. From the menu at the top of the screen, select and click on the Operations button. This will bring up a page of different operations you can perform on a table. If you scroll down the page, you will see a box called "Copy table to (database.table)." When you are copying a table, you can choose to copy one of three ways. You can copy the table structure only, copy the data only, or you can copy both the table structure and data. This is where you will find your three copy options. Select one of the options.

Copying a table actually creates a new table altogether that is identical to the one that we are copying. So now we need to give a name to the new table. Enter the name for the new table in the box, in the blank field. When you are done, click Go.

A new screen will open in the right hand window. It will confirm that the copy was successful, and what the name of the copy is. The copied table will now be showing in the left hand window, below the database, as a second table with the new name. This is the end of the tutorial. You know how to create a copy of a database table using phpMyAdmin.






Add to Favourites Add to Favourites

Print this Article Print this Article



Was this answer helpful?

Also Read


Article Renaming database tables with phpMyAdmin
The purpose of this tutorial is to teach you how to rename database tables with phpMyAdmin. We will assume that you are already logged in to...
Views: 968

Article Deleting fields from database tables with phpMyAdmin
This tutorial is going to teach you how to delete fields from database tables using phpMyAdmin. We are going to assume that you are already logged...
Views: 1327

Article Deleting tables in a database with phpMyAdmin
This tutorial is to teach you about specific operations in phpMyAdmin. We are going to learn how to delete a table in a database with phpMyAdmin....
Views: 920

Article Searching through a database with phpMyAdmin
This tutorial is about searching through a database using phpMyAdmin. We will assume that you are logged in to phpMyAdmin. For the purpose of...
Views: 1042

Article Modifying fields in database tables with phpMyAdmin
The purpose of this tutorial is to teach you how to modify fields in database tables with phpMyAdmin. We will assume that you are logged in to...
Views: 992


 
Devlopemt Developing Applications in Agile Mode and managing Projects with specifications of Platform, technology and Backend is what Dhrusoft offers to its customers within the range of technology and services supported ....
Learn More
Devlopemt FOR WEB DESIGN, WEB APPLICATION DEVELOPMENT, PHP WEB DEVELOPMENT, MOBILE APPLICATION ETC... We Appreciate your Interest in our services.
Click Here....
Hosting Security Resources Contact Dhrusoft:
-Web Hosting
-Dedicated server
-Cloud/VPS Hosting
-Domain Names
-Email Hosting
-Web Designing
-SSL Certificate
-Firewalls and Server Security
-Private Domain Registration
-Smart Card Solution

Keep in touch with us :

RSS Twitter Facebook YouTube


Copyright@2001-2012 Dhru.com - All Rights Reserved