hostimul
All articles
Databases

How to Duplicate a Database in phpMyAdmin?

Follow the next steps to duplicate the database:

1. Log into cPanel > Go to Databases section > phpMyAdmin menu:

How to Duplicate a Database in phpMyAdmin? — screenshot 1

2. From the list on the left choose the database and click the Operations option from the top bar:

How to Duplicate a Database in phpMyAdmin? — screenshot 2

3. In the Copy database field, you should enter a name for the new duplicate database.

Please select the following options:

'Structure and Data'

'CREATE DATABASE before copying'

'Add AUTO_INCREMENT value'

and then click the Go button:

How to Duplicate a Database in phpMyAdmin? — screenshot 3