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 Uživatelům pomohlo
Byla tato odpověď nápomocná?

Related Articles

What Do I Put for the Cron Job Command ?

Linux web hosting contains the following: Shared, Reseller, VPS and Dedicated. The instructions...

How to generate/download a full backup

A complete back-up is a back-up of all of your information, e-mail, data source, etc. To run a...

How do I backup / restore / move from one cPanel host to another?

How can I recover my web page with old/previous content?Please contact us through Ticket at...

How to import your MySQL database

How can I import a database? Firstly, Login to Cpanel Simply, Go to phpMyAdmin Click...

Softaculous

Softaculous, our in-house program auto-installer, is performing on all Shared and Reseller...