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 Utilizadores acharam útil
Esta resposta foi útil?

Related Articles

How to change the password of your cPanel account

If you are missing your security password, you can demand a new unique security password through...

Connecting to an FTP server

Using the Quick Connect barUsing Site ManagerYou can use the FileZilla Site Manager to specify...

Apache mod_rewrite and Examples

Mod Reword allows you to change the URL that everyone recognizes when they check out your domain...

Create or Delete a MySQL Database

Create a MySQL Database Just Log into cPanel.Under Databases,just click MySQL...

Please read before creating an Addon Domain

About addon domainsAdd-on Websites are managed like subdomains as far as the server is involved,...