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.
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.
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.
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.
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.
Now you need to scroll to the output section and check the ‘Save output to a file’ option.
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.
On the next screen, enter a name for your new database and click on ‘Create database’ button to continue.
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.
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.
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.