Latest Tech and Tips

How to Duplicate WordPress Database using phpMyAdmin

12

Do you desire to duplicate your WordPress database using phpMyAdmin? WordPress shops all your internet site information in a MySQL database. Sometimes you might require to rapidly duplicate a WordPress database to transfer an internet site or to produce hands-on back-ups. In this post, we will certainly reveal you how to quickly duplicate WordPress databaseusing phpMyAdmin

duplicate or clone WordPress database using phpMyAdmin

Why Use phpMyAdmin to Duplicate WordPress Database

WordPress shops all your internet site material in the database. Almost all WordPress organizing business provide MySQL as your database administration software program. You can connect with MySQL using command line devices, yet that is not optimal for newbies.

PhpMyAdmin uses an internet based user interface to handle your MySQL database. It can be utilized to by hand backup your WordPress database, recover admin password, or relocate your internet site to brand-new web server.

You can discover more concerning it in our overview on how to take care of WordPress database with phpMyAdmin.

That being claimed, allow’s have a look at how to duplicate WordPress databaseusing phpMyAdmin

Duplicate/ Clone WordPress Database using phpMyAdmin

First, you require to check out the cPanel control panel of your organizing account. Once visited, scroll down to the Databases area as well as click the phpMyAdmin symbol.

phpMyAdmin icon in cPanel

Don’ t fear if your cPanel control panel looks a little bit various than our screenshots, or if your organizing business does not have a cPanel control panel. You simply require to situate the data sources area, as well as you’ll locate the choice to openphpMyAdmin

This will certainly take you to the phpMyAdmin user interface where you require to click the Databases web link on the top to proceed.

Select your WordPress database

On this display, you will certainly see a listing of data sources readily available. You requirement to click your WordPress database from the checklist.

Next, you’ll see the checklist of tables in your WordPress database. Click on the ‘Operations’ web link from the leading food selection to proceed.

Database operations in my phpmyadmin

Now, you require to give a name for the brand-new duplicate database under the ‘Copy database to’ box. Make certain the ‘Structure and Data’ choice is picked and after that click the Go switch.

Copy database

PhpMyAdmin will certainly currently produce a duplicate WordPress database for you. Once ended up, you will certainly see a success message.

After that you can click ‘Databases’ web link on the leading to watch your freshly produced duplicate database.

Manually Duplicate WordPress Database using phpMyAdmin

If you get on a shared WordPress organizing, after that it is most likely that your organizing business does not permit individuals to produce data sources straight fromphpMyAdmin

In that situation, you will certainly not be able to see the ‘Copy database to’ box on the procedures web page.

However, you can still export the existing database and after that import it right into a brand-new database. To do that, check out the phpMyAdmin in your cPanel control panel.

After choosing your WordPress database, click the export switch on the leading food selection and after that choose custom-made approach.

Export database using phpMyAdmin

Now you require to scroll to the result area as well as examine the ‘Save output to a file’ choice.

Output settings

Click on the ‘Go’ switch to proceed.

phpMyAdmin will certainly currently export your WordPress database as well as send it to your internet browser as a.mysql data.

Next, you require to produce a brand-new database where you can import this data. Visit the cPanel control panel as well as click ‘MySQL Databases’ symbol.

MySQL databases in cPanel

On the following display, go into a name for your brand-new database as well as click ‘Create database’ switch to proceed.

New database

Cpanel will certainly currently produce a brand-new MySQL database. However, in order to make use of the database you require to designate it to a MySQL customer.

Scroll down to ‘Add user to database’ area as well as choose your MySQL username and after that choose your freshly produced database.

Add user to database

After that, click the Add switch to proceed.

Cpanel will certainly currently approve the MySQL customer complete opportunities on your freshly produced database.

Now that your brand-new database prepares, you can proceed as well as open phpMyAdmin from your cPanel control panel.

You requirement to choose your freshly produced database and after that click the import switch from leading food selection.

Import database

Next, click the pick data switch to choose the.mysql submit you downloaded and install earlier as well as click the Go switch to proceed.

PhpMyAdmin will certainly currently post the data from your computer system as well as import your database. You will certainly see a success message upon conclusion.

Successfully imported WordPress database

We wish this post aided you find out how to duplicate WordPress databaseusing phpMyAdmin If you’re searching for a much more effective method to back-up as well as handle your internet site, after that take a look at our checklist of the very best WordPress back-up plugins.

If you liked this post, after that please subscribe to our YouTube Channel for WordPress video clip tutorials. You can additionally locate us on Twitter as well as Facebook.