February 4, 2019
1 min Read
Domantas G.
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.
Before you begin this guide you’ll need the following:
Log in to your cPanel and navigate to phpMyAdmin section:
From the left hand-side select a database you want to copy:
Select Operations from the menu to view possible actions with 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.
Now you know how to duplicate a database using phpMyAdmin. You can make changes to this database without risk breaking your website.
LEAVE A REPLY