How to copy a database in phpMyAdmin



  •     Choose the database which you would like to duplicate (by simply clicking the database name from the phpMyAdmin home).
  •     Once you are inside the database, choose the Operations tab.
  •     Search down to the section where it says "Copy database to"
  •     Type in the name of the new information source.
  •     Choose "structure and data" to duplicate everything.  Alternatively, you can choose "Structure only" if you want the columns but not the data.
  •     Select the box "CREATE DATABASE before copying" to make a new database.
  •     Select the box "Add AUTO_INCREMENT value."
  •     Simply select the Go button to proceed.

If you simply select the home symbol, you will notice your new database listed in the left line.  If you go within it, you will see the information source is a duplicate of the previous database.
  • 4 משתמשים שמצאו מאמר זה מועיל
?האם התשובה שקיבלתם הייתה מועילה

Related Articles

How to Change DNS Zones (MX, CNAME, and A records)

SharedWith cPanel 11.34, customers are provided accessibility to make some of these changes from...

Custom error pages

To make a customized error web page for your consideration, please sign in to cPanel and...

How to log into cPanel

cPanel (control Panel) is a management tool based on web technologies for managing sites easily,...

How to view website statistics in cPanel using AWStats

When you have a website, you may want to check on how many individuals are arriving to your...

What is the difference between parked, addon, and subdomains?

A Subdomain is a second web page, with its own original material, but there is no new domain...