This guide is for users who want to clone their MySQL
database through phpMyAdmin
Besides using the command line or dashboard to
export, import way to duplicate a database, user have the option to
use phpMyadmin function to clone their database.
After accessing phpMyAdmin via cPanel / Helm /
WebSitePanel,
Select the
database user want to copy (by clicking on the database from the
phpMyAdmin home screen).
Once inside the
database, select the Operations tab.
Scroll down to the
section where it says "Copy database to:"
Type in the name
of the new database.
Select "structure
and data" to copy everything. Alternately, user can
select "Structure only" if user want the columns but not
the data.
Check the box
"CREATE DATABASE before copying" to
create a new database.
Check the box "Add
AUTO_INCREMENT value."
Click on the Go button to
proceed.
If click on the home icon, user will notice
the new database listed in the left column. By going inside, user
will find the database is a copy of the previous database.

Article ID: 3791, Created: June 28, 2014 at 10:04 AM, Modified: July 17, 2014 at 2:53 PM