Do you need to duplicate your WordPress database utilizing phpMyAdmin? WordPress shops all of your web site knowledge in a MySQL database. Generally chances are you’ll must rapidly clone a WordPress database to switch an internet site or to create handbook backups. On this article, we are going to present you methods to simply duplicate WordPress database utilizing phpMyAdmin.
Why Use phpMyAdmin to Duplicate WordPress Database
WordPress shops all of your web site content material within the database. Virtually all WordPress internet hosting corporations provide MySQL as your database administration software program. You possibly can work together with MySQL utilizing command line instruments, however that isn’t ideally suited for newbies.
PhpMyAdmin affords an online primarily based interface to handle your MySQL database. It may be used to manually backup your WordPress database, restore admin password, or transfer your web site to new server.
You possibly can study extra about it in our information on methods to handle WordPress database with phpMyAdmin.
That being stated, let’s check out methods to duplicate WordPress database utilizing phpMyAdmin.
Duplicate / Clone WordPress Database utilizing phpMyAdmin
First, you must go to the cPanel dashboard of your internet hosting account. As soon as logged in, scroll right down to the Databases part and click on on the phpMyAdmin icon.
Don’t fear in case your cPanel dashboard seems slightly completely different than our screenshots, or in case your internet hosting firm doesn’t have a cPanel dashboard. You simply must find the databases part, and also you’ll discover the choice to open phpMyAdmin.
It will take you to the phpMyAdmin interface the place you must click on on the Databases hyperlink on the highest to proceed.
On this display screen, you will note a listing of databases out there. It is advisable click on in your WordPress database from the record.
Subsequent, you’ll see the record of tables in your WordPress database. Click on on the ‘Operations’ hyperlink from the highest menu to proceed.
Now, you must present a reputation for the brand new duplicate database beneath the ‘Copy database to’ field. Be sure that the ‘Construction and Information’ choice is chosen after which click on on the Go button.
PhpMyAdmin will now create a reproduction WordPress database for you. As soon as completed, you will note a hit message.
After that you could click on on ‘Databases’ hyperlink on the highest to view your newly created duplicate database.
Manually Duplicate WordPress Database utilizing phpMyAdmin
If you’re on a shared WordPress internet hosting, then it’s doubtless that your internet hosting firm doesn’t enable customers to create databases straight from phpMyAdmin.
In that case, you won’t be able to see the ‘Copy database to’ field on the operations web page.
Nonetheless, you’ll be able to nonetheless export the prevailing database after which import it into a brand new database. To try this, go to the phpMyAdmin in your cPanel dashboard.
After deciding on your WordPress database, click on on the export button on the highest menu after which choose customized methodology.
Now you must scroll to the output part and test the ‘Save output to a file’ choice.
Click on on the ‘Go’ button to proceed.
phpMyAdmin will now export your WordPress database and ship it to your browser as a .mysql file.
Subsequent, you must create a brand new database the place you’ll be able to import this file. Go to the cPanel dashboard and click on on ‘MySQL Databases’ icon.
On the subsequent display screen, enter a reputation to your new database and click on on ‘Create database’ button to proceed.
Cpanel will now create a brand new MySQL database. Nonetheless, with the intention to use the database you must assign it to a MySQL consumer.
Scroll right down to ‘Add consumer to database’ part and choose your MySQL username after which choose your newly created database.
You May Also Like : How to Fix 503 Service Unavailable Error in WordPress
After that, click on on the Add button to proceed.
Cpanel will now grant the MySQL consumer full privileges in your newly created database.
Now that your new database is prepared, you’ll be able to go forward and open phpMyAdmin out of your cPanel dashboard.
It is advisable choose your newly created database after which click on on the import button from prime menu.
Subsequent, click on on the select file button to pick the .mysql file you downloaded earlier and click on on the Go button to proceed.
PhpMyAdmin will now add the file out of your pc and import your database. You will note a hit message upon completion.
We hope this text helped you discover ways to duplicate WordPress database utilizing phpMyAdmin. For those who’re in search of a extra environment friendly strategy to backup and handle your web site, then try our record of the finest WordPress backup plugins.
If you liked this article, make sure to hit the bell for getting our latest updates and share this article with your friends in every social media platforms.