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:

Step 2 – Selecting a database you want to duplicate

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

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

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:

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.

Conclusion

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

The Author

Domantas G. / @domantas Follow @domantasg1

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.