How to Duplicate WordPress Database using phpMyAdmin

Do you want to duplicate your WordPress database using phpMyAdmin? WordPress stores all your website data in a MySQL database. Sometimes you may need to quickly clone a WordPress database to transfer a website or to create manual backups. In this article, we will show… Read More »

The post How to Duplicate WordPress Database using phpMyAdmin appeared first on WPBeginner.

Do you want to duplicate your WordPress database using phpMyAdmin? WordPress stores all your website data in a MySQL database. Sometimes you may need to quickly clone a WordPress database to transfer a website or to create manual backups. In this article, we will show you how to easily duplicate WordPress database using phpMyAdmin.

duplicate or clone WordPress database using phpMyAdmin

Why Use phpMyAdmin to Duplicate WordPress Database

WordPress stores all your website content in the database. Almost all WordPress hosting companies offer MySQL as your database management software. You can interact with MySQL using command line tools, but that is not ideal for beginners.

PhpMyAdmin offers a web based interface to manage your MySQL database. It can be used to manually backup your WordPress database, restore admin password, or move your website to new server.

You can learn more about it in our guide on how to manage WordPress database with phpMyAdmin.

That being said, let’s take a look at how to duplicate WordPress database using phpMyAdmin.

Duplicate / Clone WordPress Database using phpMyAdmin

First, you need to visit the cPanel dashboard of your hosting account. Once logged in, scroll down to the Databases section and click on the phpMyAdmin icon.

phpMyAdmin icon in cPanel

Don’t worry if your cPanel dashboard looks a little different than our screenshots, or if your hosting company doesn’t have a cPanel dashboard. You just need to locate the databases section, and you’ll find the option to open phpMyAdmin.

This will take you to the phpMyAdmin interface where you need to click on the Databases link on the top to continue.

Select your WordPress database

On this screen, you will see a list of databases available. You need to click on your WordPress database from the list.

Next, you’ll see the list of tables in your WordPress database. Click on the ‘Operations’ link from the top menu to continue.

Database operations in my phpmyadmin

Now, you need to provide a name for the new duplicate database under the ‘Copy database to’ box. Make sure the ‘Structure and Data’ option is selected and then click on the Go button.

Copy database

PhpMyAdmin will now create a duplicate WordPress database for you. Once finished, you will see a success message.

After that you can click on ‘Databases’ link on the top to view your newly created duplicate database.

Manually Duplicate WordPress Database using phpMyAdmin

If you are on a shared WordPress hosting, then it is likely that your hosting company does not allow users to create databases directly from phpMyAdmin.

In that case, you will not be able to see the ‘Copy database to’ box on the operations page.

However, you can still export the existing database and then import it into a new database. To do that, visit the phpMyAdmin in your cPanel dashboard.

After selecting your WordPress database, click on the export button on the top menu and then select custom method.

Export database using phpMyAdmin

Now you need to scroll to the output section and check the ‘Save output to a file’ option.

Output settings

Click on the ‘Go’ button to continue.

phpMyAdmin will now export your WordPress database and send it to your browser as a .mysql file.

Next, you need to create a new database where you can import this file. Visit the cPanel dashboard and click on ‘MySQL Databases’ icon.

MySQL databases in cPanel

On the next screen, enter a name for your new database and click on ‘Create database’ button to continue.

New database

Cpanel will now create a new MySQL database. However, in order to use the database you need to assign it to a MySQL user.

Scroll down to ‘Add user to database’ section and select your MySQL username and then select your newly created database.

Add user to database

After that, click on the Add button to continue.

Cpanel will now grant the MySQL user full privileges on your newly created database.

Now that your new database is ready, you can go ahead and open phpMyAdmin from your cPanel dashboard.

You need to select your newly created database and then click on the import button from top menu.

Import database

Next, click on the choose file button to select the .mysql file you downloaded earlier and click on the Go button to continue.

PhpMyAdmin will now upload the file from your computer and import your database. You will see a success message upon completion.

Successfully imported WordPress database

We hope this article helped you learn how to duplicate WordPress database using phpMyAdmin. If you’re looking for a more efficient way to backup and manage your website, then check out our list of the best WordPress backup plugins.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Duplicate WordPress Database using phpMyAdmin appeared first on WPBeginner.