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.

Do you want to duplicate 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 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

How to duplicate wordpress phpmyadmin 2 database

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 3 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).

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

Easily create your website with Elementor

Elementor lets you create Easily and Free any website or blog design with a professional look. Stop paying a lot for a website you can do yourself.

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

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.

How to duplicate wordpress phpmyadmin 4 database

After selecting your WordPress database, click the Export button on the main menu, and then select a custom method.

How to duplicate wordpress phpmyadmin 5 database

Then you need to scroll down to the section Output and check the option «Save output to file» .

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.

Do you want to sell your products on the internet?

Download WooCommerce for free, the best e-commerce plugins to sell your physical and digital products on WordPress and easily create your online store. Perfect for beginners.

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.

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.

How to duplicate wordpress phpmyadmin 6 database

You must select your newly created database, then click on the button importer in the main menu.

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. Easy Video Player

Easy Video Player is primarily a video player for WordPress websites, but it can also be easily used to create a video background. Like many of the other WordPress plugins on this list, you can link to videos from your YouTube or Vimeo accounts, but you can also play videos from your server.

Its best features are: optimization for mobiles and desktops, responsive layout, full screen availability, and more.

See also: How to use colors on your blog and boost your sales

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

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

...