Are you questioning methods to duplicate your WordPress database utilizing phpMyAdmin?
Whether or not you wish to arrange an online growth setting or switch your web site to a brand new host, you’ll need to learn to duplicate your WordPress database. If you’re a newbie, the simplest approach 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 strategy of duplicating your WordPress database utilizing phpMyAdmin.
Knowledgeable Tip: In search of a simple approach to duplicate your whole web site, together with its database, plugins, themes, content material, and recordsdata? Simply try our information on methods to clone a WordPress web site with the Duplicator plugin.
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. When you use a WordPress internet hosting service, then your information is almost definitely saved and arranged in a MySQL database.
The factor is, to work together with MySQL, you’ll sometimes have to be aware of command-line instruments, which will be troublesome 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 put in writing advanced instructions, similar to duplicating your WordPress database. Apart from that, you should use it to:
With that in thoughts, let’s check out methods to duplicate a WordPress database utilizing phpMyAdmin. We’ll cowl totally different strategies, and you should use the hyperlinks under to shortly bounce 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 setting for testing updates and modifications.
First, that you must 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 related.
As soon as you’re logged in to cPanel, merely discover the phpMyAdmin icon. It’s often contained in the ‘Databases’ part.
Now, you’re 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 identify is, it’s the identify you enter if you first put in WordPress. You can even discover it in your wp-config.php file if you happen to neglect.
Subsequent, you will notice 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 bit known as ‘Copy database to.’
Within the empty area, merely write the brand new database identify. Then, be sure that the ‘Construction and information’ field is checked. This feature will copy each the construction and information of the database.
Moreover, the ‘CREATE DATABASE earlier than copying’ possibility ought to be ticked. This can mechanically create a brand new database the place the duplicated information might be positioned.
The remainder of the settings will be left as is. All that you must 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 greatest in case your internet hosting firm doesn’t permit customers to create databases immediately from phpMyAdmin. This can be the case in case you are utilizing shared internet hosting companies the place sure privileges are restricted for safety causes.
On this state of affairs, it’s possible 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 an alternative.
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, that you must choose ‘Customized – show all potential choices’ within the ‘Export technique’ part.
As soon as carried out, simply scroll to the Output part and select the ‘Save output to a file’ possibility. This can guarantee 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, that you must 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, that you must fill out your new database identify. In our instance, we used _copy after the unique database identify to distinguish the previous identify 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 that to decide on the brand new database you’ve simply created within the ‘Database’ area.
As soon as carried out, click on ‘Add.’
You’ll now be redirected to the ‘Handle Person Privileges’ web page.
Merely verify the ‘ALL PRIVILEGES’ possibility 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 laptop and import your database.
And that’s all! You’ve 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 essential as the way it seems on the surface. The way you deal with your database impacts how briskly your web site hundreds, how safe it’s, and the way simply individuals can use it.
In case your database is cluttered with pointless information, it may decelerate your web site and make it susceptible to safety dangers. Commonly optimizing your database can stop 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 methods to optimize your WordPress database with one click on.
We hope this text has helped you learn to duplicate a WordPress database utilizing phpMyAdmin. You may additionally wish to see our knowledgeable choose of the perfect WordPress database administration plugins and our tutorial on methods to repair the establishing a database connection error in WordPress.
When you favored this text, then please subscribe to our YouTube Channel for WordPress video tutorials. You can even discover us on Twitter and Fb.