Skip to Main Content

How to duplicate a WordPress database with phpMyAdmin

Divi: the easiest WordPress theme to use

Divi: The best WordPress theme of all time!

With over 901.000 downloads, Divi is the most popular WordPress theme in the world. It is complete, easy to use and comes with more than 62 free templates. [Recommended]

Do you want to duplicate has a WordPress database with phpMyAdmin? 

WordPress stores all the data for your website in a MySQL database. But, there will come a time when you may need to quickly clone a WordPress database to move a website ou create manual backups

In this tutorial, we will show you how to easily duplicate the WordPress database using phpMyAdmin.

But before, if you have never installed WordPress discover How to Install a WordPress Blog in 7 Steps et How to search, install and activate a WordPress theme on your blog 

Then back to why we are here.

duplicate a WordPress database with phpMyAdmin

Why use phpMyAdmin to duplicate a database

WordPress stores all of your website content in the database. Almost all WordPress hosting companies offer MySQL as their database management software. You can interact with MySQL using command line tools, but it's not ideal for newbies.

PhpMyAdmin offers a web interface to manage your MySQL database. It can be used for manually back up your WordPress database , restore the administrator password ou move your website to a new server .

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

Duplicate / clone the WordPress database using phpMyAdmin

First of all, you need to go to your hosting account dashboard. Once connected, scroll to the Databases - DATABASES - section and click on the icon phpMyAdmin.

Cpanel phpmyadmin

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

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

How to duplicate wordpress phpmyadmin database

On this screen you will see a list of available databases. You must click on your WordPress database in the list.

Read also Permalink: How to customize your blog links

Then you will see the list of tables in your WordPress database. Click on the 'Operations' link on the main menu to continue.How to duplicate wordpress phpmyadmin 2 database

Now you have to provide a name for the new database cloned in the zone « Copy the database to«   . Make sure that the option 'Structure and data'is selected, then click on the' Go" page (in French).How to duplicate wordpress phpmyadmin 3 database

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

Then you can click on the link " Databases At the top to display your new database.

Easily create your website with Elementor

Elementor allows you to easily create any website design with a professional look. Stop paying expensive for what you can do yourself. [Free]

Manually duplicate a WordPress database using phpMyAdmin

If you are on shared WordPress hosting, chances are your hosting company does not allow users to create databases directly from phpMyAdmin.

See also our tutorial on How to move a WordPress blog from local to an online website

In this case, you will not be able to see the " Copy the database to On the operations page.

However, you can still export the existing database and then import it to a new database. To do this, go to phpMyAdmin in your cPanel dashboard.

After selecting your WordPress database, click the Export button on the main menu, and then select a custom method.How to duplicate wordpress phpmyadmin 4 database

Then you need to scroll down to the section Output and check the option «Save output to file» .How to duplicate wordpress phpmyadmin 5 database

Click on the button 'Go' to continue.

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

Then you need to create a new database where you can import this file. Visit the cPanel dashboard and click on the icon 'MySQL databases'.

Create a database

On the next screen, enter a name for your new database and click the " Create a database " to continue.

Create a cpanel database

Cpanel will create a new MySQL database. However, to use the database, you must assign it to a MySQL user.

Scroll down to the "Add a user to the databaseAnd select your MySQL username, then select your newly created database.

Add User

Then click the Add button to continue.

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

Are you looking for the best WordPress themes and plugins?

Download the best plugins and WordPress themes on Envato and easily create your website. Already more than 49.720.000 downloads. [EXCLUSIVE]

Also read our guide on How to set up your WordPress dashboard

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

You must select your newly created database, then click on the button importer in the main menu.How to duplicate wordpress phpmyadmin 6 database

Then click the Choose File button to select the .mysql file that you downloaded earlier and click the " Go " to continue.

PhpMyAdmin will download the file from your computer and import your database. You will see a success message when finished.

Discover also some premium WordPress plugins  

You can use other WordPress plugins to give a modern look and optimize the grip of your blog or website.

We offer you here some premium WordPress plugins that will help you do that.

1. Slider Pro

Slider Pro is one of CodeCanyon's top three sellers. It provides a clean and intuitive user interface in the administration area and a smooth browsing experience for users and visitors.Slider pro responsive wordpress slider plugin

It avoids unnecessary fantasies, which are often an obstacle for users who are looking for the information they need. In addition, it focuses on simplicity and performance, while offering a wide range of customization possibilities.

See also How to create a slideshow with Slider Revolution on WordPress

Its management of Urls on the browser's search bar is one of the features that marked us on the latter. As the name suggests, this is the professional solution you need.

Read also our 5 WordPress plugins to create FAQs on a blog

Its features are: theoptimized harnessing of images, the peasy customization,Flowing nimations, pmany layouts et more.

Download | Demo | Web hosting

2. Ultimate GDPR Compliance jQuery Toolkit

Ultimate GDPR Compliance Toolkit is a premium WordPress plugin that has been specially developed for the protection of GDPR data.

ultimate gdpr compliance jquery.jpg

This WordPress plugin allows you to create categories of cookies that can be accepted by visitors.

See also these 4 Keys To Your Success In Online Network Marketing

You also have a report on the use of cookies a checkbox on the forms that collect user information.

Download | Demo Web hosting

3. Ultimate Membership Pro

Ultimate Membership Pro is a very popular premium WordPress plugin, which sets up an exclusive access system on your website on multiple levels. This system is configured according to the different types of packages of your users (free or paid).Ultimate membership pro wordpress membership wordpress plugin

Easily create your Online Store

Download free WooCommerce, the best e-commerce plugins to sell your physical and digital products on WordPress. [Recommended]

Its main features are: nunlimited subscription levels (free / paid), content protection, multiple levels of content restriction, support for ppayment slogans: PayPal, Authorize.net, Stripe, 2CheckOut, BrainTree, Payza, bank transfer, afree / paid trial period, the support of Visual Composer, etc ...

Download | Demo | Web hosting   

Recommended Resources

Find out about other recommended resources to help you build and manage your website.

Conclusion

Here ! That's it for this tutorial, hope it will allow you to easily duplicate your WordPress database. If you have suggestions or remarks, leave them in our section Comments.

However, you will also be able to consult our resources, if you need more elements to carry out your projects of creation of Internet sites, by consulting our guide on the WordPress blog creation.

Feel free to share this article with your friends on your favorite social networks

... 

This article features 0 comments

Leave a comment

Your email address will not be published. Required fields are marked with *

This site uses Akismet to reduce unwanted. Learn more about how your comments data is used.

Back To Top
18 shares
Share16
tweet1
Save1