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.
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.
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.
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.
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"
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.
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.
Then you need to scroll down to the section Trip 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'.
On the next screen, enter a name for your new database and click the " Create a database " to continue.
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.
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.
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 appearance and to optimize the handling 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 others WordPress plugins From 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 WordPress Plugin premium which was developed especially for GDPR data protection.
Ce 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 WordPress Plugin very popular premium, which sets up an exclusive multi-level access system on your website. This system is configured according to the different types of plans of your users (free or paid).
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, andtc ...
Download | Demo | Web hosting
Recommended Resources
Find out about other recommended resources to help you build and manage your website.
- 6 WordPress plugins to ensure GDPR compliance of a blog
- How to remove a WordPress theme from a website
- 15 WordPress plugins to create a Booking website
- 50 WooCommerce plugins to improve your online shop
- 5 WordPress plugins to protect your blog against malware
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.
...