Are you questioning the right way to duplicate your WordPress database utilizing phpMyAdmin?

Whether or not you need to arrange an online improvement atmosphere or switch your website to a brand new host, you have to to discover ways to duplicate your WordPress database. If you’re a newbie, the simplest means to do that is with phpMyAdmin, which is an online software for managing databases.

On this information, we’ll stroll you thru the step-by-step technique of duplicating your WordPress database utilizing phpMyAdmin.

Why Ought to You Use phpMyAdmin to Duplicate WordPress Database?

phpMyAdmin is an online software that helps web site house owners handle their databases.

Primarily, WordPress shops all of your web site content material in a database. Should you use a WordPress internet hosting service, then your knowledge is most certainly saved and arranged in a MySQL database.

The factor is, to work together with MySQL, you’ll sometimes must be acquainted with command-line instruments, which might be tough in case you are a newbie.

That is the place phpMyAdmin is available in. It has a user-friendly interface that allows you to do varied database-related duties with out having to jot down advanced instructions, akin to duplicating your WordPress database. Apart from that, you should use it to:

With that in thoughts, let’s check out the right way to duplicate a WordPress database utilizing phpMyAdmin. We are going to cowl totally different strategies, and you should use the hyperlinks beneath to shortly leap to every one:

Technique 1: Cloning Your WordPress Database With phpMyAdmin

This technique is appropriate if you wish to manually create a backup or arrange a staging atmosphere for testing updates and adjustments.

First, it is advisable to open your WordPress internet hosting management panel. In our tutorial, we’re working with Bluehost, which makes use of cPanel for its internet hosting account administration. Your management panel might look barely totally different from our screenshots, however the steps might be comparable.

As soon as you might be logged in to cPanel, merely discover the phpMyAdmin icon. It’s often contained in the ‘Databases’ part.

Now, you might be inside your hosting’s phpMyAdmin. Right here, simply click on the ‘Databases’ tab on the prime and choose your WordPress database from the listing of databases.

If you’re undecided what your database title is, it’s the title you enter once you first put in WordPress. You may as well discover it in your wp-config.php file should you neglect.

Subsequent, you will note a listing of your WordPress database tables.

On this web page, simply click on on the ‘Operations’ tab from the highest menu.

That is the place you’ll duplicate your database. Go forward and scroll all the way down to a piece known as ‘Copy database to.’

Within the empty area, merely write the brand new database title. Then, make certain the ‘Construction and knowledge’ field is checked. This selection will copy each the construction and knowledge of the database.

Moreover, the ‘CREATE DATABASE earlier than copying’ choice needs to be ticked. This may robotically create a brand new database the place the duplicated knowledge might be situated.

The remainder of the settings might be left as is. All it is advisable to do subsequent is click on ‘Go’ on the backside.

And that’s it! Your database has been efficiently cloned.

After this, you may navigate to your newly duplicated database from the left panel.

Technique 2: Exporting and Importing WordPress Database With phpMyAdmin

This second technique is finest in case your internet hosting firm doesn’t enable customers to create databases instantly from phpMyAdmin. This can be the case in case you are utilizing shared internet hosting providers the place sure privileges are restricted for safety causes.

On this state of affairs, chances are you’ll not have the ability to see the ‘Copy database to’ part within the ‘Operations’ tab. To duplicate your database, you should use the export technique as a substitute.

Primarily, you’ll export your database SQL file, arrange a brand new database, after which import that database into the brand new setup.

Step one is to go to phpMyAdmin and choose your WordPress database like we did within the earlier technique. Then, within the prime menu, merely click on the ‘Export’ button.

Right here, it is advisable to choose ‘Customized – show all potential choices’ within the ‘Export technique’ part.

As soon as executed, simply scroll to the Output part and select the ‘Save output to a file’ choice. This may be sure that your database is exported as an SQL file.

For the remainder of the settings, you may depart them as they’re.

Now, all you must do is scroll all the way down to the underside and click on ‘Export.’

Your browser will now obtain the WordPress database as an .sql file.

Subsequent, it is advisable to create a brand new database the place you may import this file to.

Go forward and open your internet hosting management panel and click on on ‘MySQL Databases.’

On this web page, it is advisable to fill out your new database title. In our instance, we used _copy after the unique database title to distinguish the outdated title from the newly duplicated one.

After that, simply click on the ‘Create Database’ button.

Now that we’ve created a brand new database, let’s assign it to a MySQL person.

Go forward and scroll down the ‘Add Person to Database’ part and choose a MySQL username from the dropdown menu. Ensure to decide on the brand new database you’ve simply created within the ‘Database’ area.

As soon as executed, click on ‘Add.’

You’ll now be redirected to the ‘Handle Person Privileges’ web page.

Merely verify the ‘ALL PRIVILEGES’ choice if you wish to have complete management over your database.

Then, go all the way in which all the way down to the underside of the web page and click on ‘Make Adjustments.’

Your newly created database is now prepared.

Let’s go forward and open phpMyAdmin once more and choose the database you simply created in cPanel.

As soon as inside, you’ll see that the database is empty with out tables like this:

To proceed, merely go to the ‘Import’ web page from the highest menu.

Right here, click on on the ‘Select File’ button to pick out the .sql file you downloaded earlier.

As soon as completed, scroll all the way down to the underside and click on the ‘Import’ button.

phpMyAdmin will now add the file out of your pc and import your database.

And that’s all! You’ve gotten efficiently imported your duplicated database.

Bonus: Optimize Your WordPress Database for Higher Efficiency

Managing the behind-the-scenes a part of your WordPress web site is simply as necessary as the way it seems on the skin. The way you deal with your database impacts how briskly your website masses, how safe it’s, and the way simply folks can use it.

In case your database is cluttered with pointless knowledge, it will probably decelerate your website and make it weak to safety dangers. Usually optimizing your database can forestall this from occurring and make your web site extra dependable.

For extra details about database administration, you may see our newbie’s information on managing a WordPress database with phpMyAdmin and our article on the right way to optimize your WordPress database with one click on.

We hope this text has helped you discover ways to duplicate a WordPress database utilizing phpMyAdmin. You may additionally need to see our knowledgeable choose of the very best WordPress database administration plugins and our tutorial on the right way to repair the establishing a database connection error in WordPress.

Should you appreciated this text, then please subscribe to our YouTube Channel for WordPress video tutorials. You may as well discover us on Twitter and Facebook.