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.
![How to Duplicate WordPress Database Using phpMyAdmin How to Duplicate WordPress Database Using phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/how-to-duplicate-wordpress-database-using-phpmyadmin-og-1.png)
Professional Tip: In search of a simple technique to duplicate your whole web site, together with its database, plugins, themes, content material, and information? Simply try our information on the right way to clone a WordPress website 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. 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.
![Selecting phpMyAdmin on cPanel Selecting phpMyAdmin on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/cpanel-phpmyadmin-min.png)
![Selecting phpMyAdmin on cPanel Selecting phpMyAdmin on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/cpanel-phpmyadmin-min.png)
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.
![Selecting a database on phpMyAdmin Selecting a database on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/selecting-database-phpmyadmin-min.png)
![Selecting a database on phpMyAdmin Selecting a database on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/selecting-database-phpmyadmin-min.png)
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.
![Selecting the Operations tab on phpMyAdmin Selecting the Operations tab on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/select-operations-phpmyadmin-min.png)
![Selecting the Operations tab on phpMyAdmin Selecting the Operations tab on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/select-operations-phpmyadmin-min.png)
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.
![The 'Copy database to' section on phpMyAdmin The 'Copy database to' section on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/copy-database-to-phpmyadmin-min.jpg)
![The 'Copy database to' section on phpMyAdmin The 'Copy database to' section on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/copy-database-to-phpmyadmin-min.jpg)
And that’s it! Your database has been efficiently cloned.
After this, you may navigate to your newly duplicated database from the left panel.
![Navigating to a newly duplicated database on phpMyAdmin Navigating to a newly duplicated database on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/navigate-copy-database-min.jpg)
![Navigating to a newly duplicated database on phpMyAdmin Navigating to a newly duplicated database on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/navigate-copy-database-min.jpg)
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.
![Opening the 'Export' tab on phpMyAdmin and selecting the Custom option Opening the 'Export' tab on phpMyAdmin and selecting the Custom option](https://www.wpbeginner.com/wp-content/uploads/2017/09/selecting-export-phpmyadmin-min.png)
![Opening the 'Export' tab on phpMyAdmin and selecting the Custom option Opening the 'Export' tab on phpMyAdmin and selecting the Custom option](https://www.wpbeginner.com/wp-content/uploads/2017/09/selecting-export-phpmyadmin-min.png)
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.
![Configuring the phpMyAdmin Export Output settings Configuring the phpMyAdmin Export Output settings](https://www.wpbeginner.com/wp-content/uploads/2017/09/phpmyadmin-export-output-settings-min.png)
![Configuring the phpMyAdmin Export Output settings Configuring the phpMyAdmin Export Output settings](https://www.wpbeginner.com/wp-content/uploads/2017/09/phpmyadmin-export-output-settings-min.png)
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.
![Clicking the Export button on phpMyAdmin Clicking the Export button on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/database-export-button-min.png)
![Clicking the Export button on phpMyAdmin Clicking the Export button on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/database-export-button-min.png)
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.’
![Opening the MySQL Databases page on cPanel Opening the MySQL Databases page on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/cpanel-mysql-databases-min.png)
![Opening the MySQL Databases page on cPanel Opening the MySQL Databases page on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/cpanel-mysql-databases-min.png)
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.
![Creating a new MySQL Database on cPanel Creating a new MySQL Database on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/mysql-databases-create-new-database-two-min.png)
![Creating a new MySQL Database on cPanel Creating a new MySQL Database on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/mysql-databases-create-new-database-two-min.png)
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.’
![Adding a new user to the MySQL Database on cPanel Adding a new user to the MySQL Database on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/add-user-to-database-two-min.png)
![Adding a new user to the MySQL Database on cPanel Adding a new user to the MySQL Database on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/add-user-to-database-two-min.png)
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.
![Checking the All Privileges option when adding a new MySQL user on cPanel Checking the All Privileges option when adding a new MySQL user on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/mysql-database-user-manage-privileges-min.png)
![Checking the All Privileges option when adding a new MySQL user on cPanel Checking the All Privileges option when adding a new MySQL user on cPanel](https://www.wpbeginner.com/wp-content/uploads/2017/09/mysql-database-user-manage-privileges-min.png)
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.
![Clicking the 'Make Changes' button to set the privileges of a new MySQL user on phpMyAdmin Clicking the 'Make Changes' button to set the privileges of a new MySQL user on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/mysql-database-privlege-make-changes-min.png)
![Clicking the 'Make Changes' button to set the privileges of a new MySQL user on phpMyAdmin Clicking the 'Make Changes' button to set the privileges of a new MySQL user on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/mysql-database-privlege-make-changes-min.png)
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:
![No tables found in database message on phpMyAdmin No tables found in database message on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/no-tables-found-database-min.png)
![No tables found in database message on phpMyAdmin No tables found in database message on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/no-tables-found-database-min.png)
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.
![Choosing an SQL file to import in phpMyAdmin Choosing an SQL file to import in phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/phpmyadmin-importing-current-database-min.png)
![Choosing an SQL file to import in phpMyAdmin Choosing an SQL file to import in phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/phpmyadmin-importing-current-database-min.png)
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.
![Clicking the Import button on phpMyAdmin Clicking the Import button on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/phpmyadmin-import-button-min.png)
![Clicking the Import button on phpMyAdmin Clicking the Import button on phpMyAdmin](https://www.wpbeginner.com/wp-content/uploads/2017/09/phpmyadmin-import-button-min.png)
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.
Leave a comment