MySQL

How to Copy a Database with phpMyAdmin

Introduction

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.

Conclusion

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

Add Comment

Click here to post a comment

Join thousands of subscribers worldwide

and get awesome deals & the newest tutorials to your email

Please wait...

Thank you for sign up!

More in MySQL
How to Optimize a MySQL Database Using phpMyadmin
How to Optimize a MySQL Database Using phpMyadmin

Close