How to Copy a Database with phpMyAdmin

How to Copy a Database with phpMyAdmin

You may need to copy (duplicate) an existing database in order to test changes on your website or for a similar reason. This tutorial shows you how to copy an existing database using phpMyAdmin.

What you’ll need

Before you begin this guide you’ll need the following:

  • Access to your accounts control panel

Step 1 – Navigating to phpMyAdmin

Log in to your cPanel and navigate to phpMyAdmin section:
Navigating to phpMyAdmin in cPanel

Step 2 – Selecting a database you want to duplicate

From the left hand-side select a database you want to copy:

Selecting a database to copy

Select Operations from the menu to view possible actions with the database:

Navigate to Operations in phpMyAdmin

Step 3 — Specifying where to copy the database

Find a section called Copy database to:. In the text field enter the name of a new database. Click Go to copy the database:

Specifying where to copy the database

Important! Uncheck CREATE DATABASE before copying if the database name you specified earlier already exists.

The newly created database will appear under MySQL Databases section in your hosting control panel as well as in phpMyAdmin’s list of databases on the left side.


Now you know how to duplicate a database using phpMyAdmin. You can make changes to this database without risk breaking your website.

Was this tutorial helpful?

The author

Domantas G.

Domantas leads the content and SEO teams forward with fresh ideas and out of the box approaches. Armed with extensive SEO and marketing knowledge, he aims to spread the word of Hostinger to every corner of the world. During his free time, Domantas likes to hone his web development skills and travel to exotic places.