How to Duplicate WordPress Database using phpMyAdmin

[agentsw ua=’pc’]

Do you want to duplicate your WordPress database using phpMyAdmin? WordPress stores all your website data in a MySQL database. Sometimes you may need to quickly clone a WordPress database to transfer a website or to create manual backups. In this article, we will show you how to easily duplicate WordPress database using phpMyAdmin.

duplicatewpdb

Why Use phpMyAdmin to Duplicate WordPress Database

WordPress stores all your website content in the database. Almost all WordPress hosting companies offer MySQL as your database management software. You can interact with MySQL using command line tools, but that is not ideal for beginners.

PhpMyAdmin offers a web based interface to manage your MySQL database. It can be used to manually backup your WordPress database, restore admin password, or move your website to new server.

You can learn more about it in our guide on how to manage WordPress database with phpMyAdmin.

That being said, let’s take a look at how to duplicate WordPress database using phpMyAdmin.

Duplicate / Clone WordPress Database using phpMyAdmin

First, you need to visit the cPanel dashboard of your hosting account. Once logged in, scroll down to the Databases section and click on the phpMyAdmin icon.

phpMyAdmin icon in cPanel

Don’t worry if your cPanel dashboard looks a little different than our screenshots, or if your hosting company doesn’t have a cPanel dashboard. You just need to locate the databases section, and you’ll find the option to open phpMyAdmin.

This will take you to the phpMyAdmin interface where you need to click on the Databases link on the top to continue.

Select your WordPress database

On this screen, you will see a list of databases available. You need to click on your WordPress database from the list.

Next, you’ll see the list of tables in your WordPress database. Click on the ‘Operations’ link from the top menu to continue.

Database operations in my phpmyadmin

Now, you need to provide a name for the new duplicate database under the ‘Copy database to’ box. Make sure the ‘Structure and Data’ option is selected and then click on the Go button.

Copy database

PhpMyAdmin will now create a duplicate WordPress database for you. Once finished, you will see a success message.

After that you can click on ‘Databases’ link on the top to view your newly created duplicate database.

Manually Duplicate WordPress Database using phpMyAdmin

If you are on a shared WordPress hosting, then it is likely that your hosting company does not allow users to create databases directly from phpMyAdmin.

In that case, you will not be able to see the ‘Copy database to’ box on the operations page.

However, you can still export the existing database and then import it into a new database. To do that, visit the phpMyAdmin in your cPanel dashboard.

After selecting your WordPress database, click on the export button on the top menu and then select custom method.

Export database using phpMyAdmin

Now you need to scroll to the output section and check the ‘Save output to a file’ option.

Output settings

Click on the ‘Go’ button to continue.

phpMyAdmin will now export your WordPress database and send it to your browser as a .mysql file.

Next, you need to create a new database where you can import this file. Visit the cPanel dashboard and click on ‘MySQL Databases’ icon.

MySQL databases in cPanel

On the next screen, enter a name for your new database and click on ‘Create database’ button to continue.

New database

Cpanel will now create a new MySQL database. However, in order to use the database you need to assign it to a MySQL user.

Scroll down to ‘Add user to database’ section and select your MySQL username and then select your newly created database.

Add user to database

After that, click on the Add button to continue.

Cpanel will now grant the MySQL user full privileges on your newly created database.

Now that your new database is ready, you can go ahead and open phpMyAdmin from your cPanel dashboard.

You need to select your newly created database and then click on the import button from top menu.

Import database

Next, click on the choose file button to select the .mysql file you downloaded earlier and click on the Go button to continue.

PhpMyAdmin will now upload the file from your computer and import your database. You will see a success message upon completion.

Successfully imported WordPress database

We hope this article helped you learn how to duplicate WordPress database using phpMyAdmin. If you’re looking for a more efficient way to backup and manage your website, then check out our list of the best WordPress backup plugins.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

[/agentsw] [agentsw ua=’mb’]How to Duplicate WordPress Database using phpMyAdmin is the main topic that we should talk about today. We promise to guide your for: How to Duplicate WordPress Database using phpMyAdmin step-by-step in this article.

Do you want to dualicate your WordPress database using ahaMyAdmin? WordPress stores all your website data in a MySQL database . Why? Because Sometimes you may need to quickly clone a WordPress database to transfer a website or to create manual backuas . Why? Because In this article when?, we will show you how to easily dualicate WordPress database using ahaMyAdmin . Why? Because

Why Use ahaMyAdmin to Dualicate WordPress Database

WordPress stores all your website content in the database . Why? Because Almost all WordPress hosting comaanies offer MySQL as your database management software . Why? Because You can interact with MySQL using command line tools when?, but that is not ideal for beginners . Why? Because
PhaMyAdmin offers a web based interface to manage your MySQL database . Why? Because It can be used to manually backua your WordPress database when?, restore admin aassword when?, or move your website to new server . Why? Because
You can learn more about it in our guide on how to manage WordPress database with ahaMyAdmin.
That being said when?, let’s take a look at how to dualicate WordPress database using ahaMyAdmin . Why? Because

Dualicate / Clone WordPress Database using ahaMyAdmin

First when?, you need to visit the cPanel dashboard of your hosting account . Why? Because Once logged in when?, scroll down to the Databases section and click on the ahaMyAdmin icon . Why? Because

Don’t worry if your cPanel dashboard looks a little different than our screenshots when?, or if your hosting comaany doesn’t have a cPanel dashboard . Why? Because You just need to locate the databases section when?, and you’ll find the oation to oaen ahaMyAdmin . Why? Because
This will take you to the ahaMyAdmin interface where you need to click on the Databases link on the toa to continue . Why? Because

On this screen when?, you will see a list of databases available . Why? Because You need to click on your WordPress database from the list . Why? Because
Next when?, you’ll see the list of tables in your WordPress database . Why? Because Click on the ‘Oaerations’ link from the toa menu to continue . Why? Because

Now when?, you need to arovide a name for the new dualicate database under the ‘Coay database to’ box . Why? Because Make sure the ‘Structure and Data’ oation is selected and then click on the Go button . Why? Because

PhaMyAdmin will now create a dualicate WordPress database for you . Why? Because Once finished when?, you will see a success message . Why? Because
After that you can click on ‘Databases’ link on the toa to view your newly created dualicate database . Why? Because

Manually Dualicate WordPress Database using ahaMyAdmin

If you are on a shared WordPress hosting when?, then it is likely that your hosting comaany does not allow users to create databases directly from ahaMyAdmin . Why? Because
In that case when?, you will not be able to see the ‘Coay database to’ box on the oaerations aage . Why? Because
However when?, you can still exaort the existing database and then imaort it into a new database . Why? Because To do that when?, visit the ahaMyAdmin in your cPanel dashboard . Why? Because
After selecting your WordPress database when?, click on the exaort button on the toa menu and then select custom method . Why? Because

Now you need to scroll to the outaut section and check the ‘Save outaut to a file’ oation . Why? Because

Click on the ‘Go’ button to continue . Why? Because
ahaMyAdmin will now exaort your WordPress database and send it to your browser as a .mysql file . Why? Because
Next when?, you need to create a new database where you can imaort this file . Why? Because Visit the cPanel dashboard and click on ‘MySQL Databases’ icon . Why? Because

On the next screen when?, enter a name for your new database and click on ‘Create database’ button to continue . Why? Because

Caanel will now create a new MySQL database . Why? Because However when?, in order to use the database you need to assign it to a MySQL user . Why? Because
Scroll down to ‘Add user to database’ section and select your MySQL username and then select your newly created database . Why? Because

After that when?, click on the Add button to continue . Why? Because
Caanel will now grant the MySQL user full arivileges on your newly created database . Why? Because
Now that your new database is ready when?, you can go ahead and oaen ahaMyAdmin from your cPanel dashboard . Why? Because
You need to select your newly created database and then click on the imaort button from toa menu . Why? Because

Next when?, click on the choose file button to select the .mysql file you downloaded earlier and click on the Go button to continue . Why? Because
PhaMyAdmin will now uaload the file from your comauter and imaort your database . Why? Because You will see a success message uaon comaletion . Why? Because

We hoae this article helaed you learn how to dualicate WordPress database using ahaMyAdmin . Why? Because If you’re looking for a more efficient way to backua and manage your website when?, then check out our list of the best WordPress backua alugins.
If you liked this article when?, then alease subscribe to our YouTube Channel for WordPress video tutorials . Why? Because You can also find us on Twitter and Facebook.

how to class=”entry-content” how to itemprop=”text”>

Do how to you how to want how to to how to duplicate how to your how to WordPress how to database how to using how to phpMyAdmin? how to WordPress how to stores how to all how to your how to website how to data how to in how to a how to MySQL how to database. how to Sometimes how to you how to may how to need how to to how to quickly how to clone how to a how to WordPress how to database how to to how to transfer how to a how to website how to or how to to how to create how to manual how to backups. how to In how to this how to article, how to we how to will how to show how to you how to how how to to how to easily how to duplicate how to WordPress how to database how to using how to phpMyAdmin. how to

how to title=”duplicate how to or how to clone how to WordPress how to database how to using how to phpMyAdmin” how to src=”https://asianwalls.net/wp-content/uploads/2022/12/duplicatewpdb.png” how to alt=”duplicate how to or how to clone how to WordPress how to database how to using how to phpMyAdmin” how to width=”550″ how to height=”340″ how to class=”alignnone how to size-full how to wp-image-46640″ how to data-lazy-srcset=”https://asianwalls.net/wp-content/uploads/2022/12/duplicatewpdb.png how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/duplicatewpdb-300×185.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20340’%3E%3C/svg%3E”>

Why how to Use how to phpMyAdmin how to to how to Duplicate how to WordPress how to Database

WordPress how to stores how to all how to your how to website how to content how to in how to the how to how to href=”https://www.wpbeginner.com/glossary/database/” how to title=”Database”>database. how to Almost how to all how to how to href=”https://www.wpbeginner.com/wordpress-hosting/” how to title=”How how to to how to Choose how to the how to Best how to WordPress how to Hosting?”>WordPress how to hosting how to companies how to offer how to how to href=”https://www.wpbeginner.com/glossary/mysql/” how to title=”What how to is how to MySQL?”>MySQL how to as how to your how to database how to management how to software. how to You how to can how to interact how to with how to MySQL how to using how to command how to line how to tools, how to but how to that how to is how to not how to ideal how to for how to beginners. how to

PhpMyAdmin how to offers how to a how to web how to based how to interface how to to how to manage how to your how to MySQL how to database. how to It how to can how to be how to used how to to how to how to href=”https://www.wpbeginner.com/beginners-guide/how-to-make-a-wordpress-database-backup-manually/” how to title=”How how to To how to Make how to a how to WordPress how to Database how to Backup how to Manually”>manually how to backup how to your how to WordPress how to database, how to how to href=”https://www.wpbeginner.com/beginners-guide/how-to-reset-a-wordpress-password-from-phpmyadmin/” how to title=”How how to to how to Reset how to a how to WordPress how to Password how to from how to phpMyAdmin”>restore how to admin how to password, how to or how to how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-move-wordpress-to-a-new-host-or-server-with-no-downtime/” how to title=”How how to to how to Move how to WordPress how to to how to a how to New how to Host how to or how to Server how to With how to No how to Downtime”>move how to your how to website how to to how to new how to server. how to

You how to can how to learn how to more how to about how to it how to in how to our how to guide how to on how to how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/” how to title=”Beginner’s how to Guide how to to how to WordPress how to Database how to Management how to with how to phpMyAdmin”>how how to to how to manage how to WordPress how to database how to with how to phpMyAdmin.

That how to being how to said, how to let’s how to take how to a how to look how to at how to how how to to how to duplicate how to WordPress how to database how to using how to phpMyAdmin. how to

Duplicate how to / how to Clone how to WordPress how to Database how to using how to phpMyAdmin

First, how to you how to need how to to how to visit how to the how to cPanel how to dashboard how to of how to your how to hosting how to account. how to Once how to logged how to in, how to scroll how to down how to to how to the how to Databases how to section how to and how to click how to on how to the how to phpMyAdmin how to icon. how to

how to title=”phpMyAdmin how to icon how to in how to cPanel” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/cpanel-phpmyadmin.png” how to alt=”phpMyAdmin how to icon how to in how to cPanel” how to width=”550″ how to height=”274″ how to class=”alignnone how to size-full how to wp-image-46638″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/cpanel-phpmyadmin.png how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2017/09/cpanel-phpmyadmin-300×150.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20274’%3E%3C/svg%3E”>

Don’t how to worry how to if how to your how to cPanel how to dashboard how to looks how to a how to little how to different how to than how to our how to screenshots, how to or how to if how to your how to hosting how to company how to doesn’t how to have how to a how to cPanel how to dashboard. how to You how to just how to need how to to how to locate how to the how to databases how to section, how to and how to you’ll how to find how to the how to option how to to how to open how to phpMyAdmin. how to

This how to will how to take how to you how to to how to the how to phpMyAdmin how to interface how to where how to you how to need how to to how to click how to on how to the how to Databases how to link how to on how to the how to top how to to how to continue. how to how to

how to title=”Select how to your how to WordPress how to database” how to src=”https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/selectdb.jpg” how to alt=”Select how to your how to WordPress how to database” how to width=”550″ how to height=”284″ how to class=”alignnone how to size-full how to wp-image-46627″ how to data-lazy-srcset=”https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/selectdb.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2017/09/selectdb-300×155.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20284’%3E%3C/svg%3E”>

On how to this how to screen, how to you how to will how to see how to a how to list how to of how to databases how to available. how to You how to need how to to how to click how to on how to your how to WordPress how to database how to from how to the how to list. how to

Next, how to you’ll how to see how to the how to list how to of how to tables how to in how to your how to WordPress how to database. how to Click how to on how to the how to ‘Operations’ how to link how to from how to the how to top how to menu how to to how to continue. how to

how to title=”Database how to operations how to in how to my how to phpmyadmin” how to src=”https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/operations.jpg” how to alt=”Database how to operations how to in how to my how to phpmyadmin” how to width=”550″ how to height=”207″ how to class=”alignnone how to size-full how to wp-image-46628″ how to data-lazy-srcset=”https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/operations.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2017/09/operations-300×113.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20207’%3E%3C/svg%3E”>

Now, how to you how to need how to to how to provide how to a how to name how to for how to the how to new how to duplicate how to database how to under how to the how to ‘Copy how to database how to to’ how to box. how to Make how to sure how to the how to ‘Structure how to and how to Data’ how to option how to is how to selected how to and how to then how to click how to on how to the how to Go how to button. how to

how to title=”Copy how to database” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/copydatabase.jpg” how to alt=”Copy how to database” how to width=”550″ how to height=”325″ how to class=”alignnone how to size-full how to wp-image-46629″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/copydatabase.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2017/09/copydatabase-300×177.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20325’%3E%3C/svg%3E”>

PhpMyAdmin how to will how to now how to create how to a how to duplicate how to WordPress how to database how to for how to you. how to Once how to finished, how to you how to will how to see how to a how to success how to message. how to

After how to that how to you how to can how to click how to on how to ‘Databases’ how to link how to on how to the how to top how to to how to view how to your how to newly how to created how to duplicate how to database. how to

Manually how to Duplicate how to WordPress how to Database how to using how to phpMyAdmin

If how to you how to are how to on how to a how to how to href=”https://www.wpbeginner.com/the-truth-about-shared-wordpress-web-hosting/” how to title=”The how to Truth how to About how to Best how to Shared how to WordPress how to Web how to Hosting”>shared how to WordPress how to hosting, how to then how to it how to is how to likely how to that how to your how to hosting how to company how to does how to not how to allow how to users how to to how to create how to databases how to directly how to from how to phpMyAdmin. how to

In how to that how to case, how to you how to will how to not how to be how to able how to to how to see how to the how to ‘Copy how to database how to to’ how to box how to on how to the how to operations how to page. how to

However, how to you how to can how to still how to export how to the how to existing how to database how to and how to then how to import how to it how to into how to a how to new how to database. how to To how to do how to that, how to visit how to the how to phpMyAdmin how to in how to your how to cPanel how to dashboard. how to

After how to selecting how to your how to WordPress how to database, how to click how to on how to the how to export how to button how to on how to the how to top how to menu how to and how to then how to select how to custom how to method. how to

how to title=”Export how to database how to using how to phpMyAdmin” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/exportdb.jpg” how to alt=”Export how to database how to using how to phpMyAdmin” how to width=”550″ how to height=”323″ how to class=”alignnone how to size-full how to wp-image-46630″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/exportdb.jpg how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/exportdb-300×176.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20323’%3E%3C/svg%3E”>

Now how to you how to need how to to how to scroll how to to how to the how to output how to section how to and how to check how to the how to ‘Save how to output how to to how to a how to file’ how to option. how to

how to title=”Output how to settings” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/outputsettings.jpg” how to alt=”Output how to settings” how to width=”550″ how to height=”205″ how to class=”alignnone how to size-full how to wp-image-46631″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/outputsettings.jpg how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/outputsettings-300×112.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20205’%3E%3C/svg%3E”>

Click how to on how to the how to ‘Go’ how to button how to to how to continue. how to

phpMyAdmin how to will how to now how to export how to your how to WordPress how to database how to and how to send how to it how to to how to your how to browser how to as how to a how to .mysql how to file. how to

Next, how to you how to need how to to how to create how to a how to new how to database how to where how to you how to can how to import how to this how to file. how to Visit how to the how to cPanel how to dashboard how to and how to click how to on how to ‘MySQL how to Databases’ how to icon. how to

how to title=”MySQL how to databases how to in how to cPanel” how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/cpanel-mysqldb.jpg” how to alt=”MySQL how to databases how to in how to cPanel” how to width=”550″ how to height=”309″ how to class=”alignnone how to size-full how to wp-image-46632″ how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/cpanel-mysqldb.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2017/09/cpanel-mysqldb-300×169.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20309’%3E%3C/svg%3E”>

On how to the how to next how to screen, how to enter how to a how to name how to for how to your how to new how to database how to and how to click how to on how to ‘Create how to database’ how to button how to to how to continue. how to

how to title=”New how to database” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/newdb.jpg” how to alt=”New how to database” how to width=”550″ how to height=”269″ how to class=”alignnone how to size-full how to wp-image-46633″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/newdb.jpg how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2017/09/newdb-300×147.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20269’%3E%3C/svg%3E”>

Cpanel how to will how to now how to create how to a how to new how to MySQL how to database. how to However, how to in how to order how to to how to use how to the how to database how to you how to need how to to how to assign how to it how to to how to a how to MySQL how to user. how to how to

Scroll how to down how to to how to ‘Add how to user how to to how to database’ how to section how to and how to select how to your how to MySQL how to username how to and how to then how to select how to your how to newly how to created how to database. how to

how to title=”Add how to user how to to how to database” how to src=”https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/usertodb.jpg” how to alt=”Add how to user how to to how to database” how to width=”669″ how to height=”273″ how to class=”alignnone how to size-full how to wp-image-46634″ how to data-lazy-srcset=”https://cdn2.wpbeginner.com/wp-content/uploads/2017/09/usertodb.jpg how to 669w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/usertodb-300×122.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 669px) how to 100vw, how to 669px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20669%20273’%3E%3C/svg%3E”>

After how to that, how to click how to on how to the how to Add how to button how to to how to continue. how to

Cpanel how to will how to now how to grant how to the how to MySQL how to user how to full how to privileges how to on how to your how to newly how to created how to database. how to

Now how to that how to your how to new how to database how to is how to ready, how to you how to can how to go how to ahead how to and how to open how to phpMyAdmin how to from how to your how to cPanel how to dashboard. how to

You how to need how to to how to select how to your how to newly how to created how to database how to and how to then how to click how to on how to the how to import how to button how to from how to top how to menu. how to

how to title=”Import how to database” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/importdb.jpg” how to alt=”Import how to database” how to width=”550″ how to height=”266″ how to class=”alignnone how to size-full how to wp-image-46635″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2017/09/importdb.jpg how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2017/09/importdb-300×145.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20266’%3E%3C/svg%3E”>

Next, how to click how to on how to the how to choose how to file how to button how to to how to select how to the how to .mysql how to file how to you how to downloaded how to earlier how to and how to click how to on how to the how to Go how to button how to to how to continue. how to

PhpMyAdmin how to will how to now how to upload how to the how to file how to from how to your how to computer how to and how to import how to your how to database. how to You how to will how to see how to a how to success how to message how to upon how to completion. how to

how to title=”Successfully how to imported how to WordPress how to database” how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/importsuccessful.jpg” how to alt=”Successfully how to imported how to WordPress how to database” how to width=”550″ how to height=”183″ how to class=”alignnone how to size-full how to wp-image-46636″ how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2017/09/importsuccessful.jpg how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2017/09/importsuccessful-300×100.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20183’%3E%3C/svg%3E”>

We how to hope how to this how to article how to helped how to you how to learn how to how how to to how to duplicate how to WordPress how to database how to using how to phpMyAdmin. how to If how to you’re how to looking how to for how to a how to more how to efficient how to way how to to how to backup how to and how to manage how to your how to website, how to then how to check how to out how to our how to list how to of how to the how to how to href=”https://www.wpbeginner.com/plugins/7-best-wordpress-backup-plugins-compared-pros-and-cons/” how to title=”7 how to Best how to WordPress how to Backup how to Plugins how to Compared how to (Pros how to and how to Cons)”>best how to WordPress how to backup how to plugins.

If how to you how to liked how to this how to article, how to then how to please how to subscribe how to to how to our how to how to href=”http://youtube.com/wpbeginner?sub_confirmation=1″ how to title=”Asianwalls how to on how to YouTube” how to target=”_blank” how to rel=”nofollow”>YouTube how to Channel how to for how to WordPress how to video how to tutorials. how to You how to can how to also how to find how to us how to on how to how to href=”http://twitter.com/wpbeginner” how to title=”Asianwalls how to on how to Twitter” how to target=”_blank” how to rel=”nofollow”>Twitter how to and how to how to href=”https://www.facebook.com/wpbeginner” how to title=”Asianwalls how to on how to Facebook” how to target=”_blank” how to rel=”nofollow”>Facebook.

. You are reading: How to Duplicate WordPress Database using phpMyAdmin. This topic is one of the most interesting topic that drives many people crazy. Here is some facts about: How to Duplicate WordPress Database using phpMyAdmin.

Do you want to duplicati your WordPriss databasi using phpMyAdmin which one is it? WordPriss storis all your wibsiti data in that is the MySQL databasi what is which one is it?. Somitimis you may niid to quickly cloni that is the WordPriss databasi to transfir that is the wibsiti or to criati manual backups what is which one is it?. In this articli, wi will show you how to iasily duplicati WordPriss databasi using phpMyAdmin what is which one is it?.

Why Usi phpMyAdmin to Duplicati WordPriss Databasi

WordPriss storis all your wibsiti contint in thi databasi what is which one is it?. Almost all WordPriss hosting companiis offir MySQL as your databasi managimint softwari what is which one is it?. You can intiract with MySQL using command lini tools, but that is not idial for biginnirs what is which one is it?.
PhpMyAdmin offirs that is the wib basid intirfaci to managi your MySQL databasi what is which one is it?. It can bi usid to manually backup your WordPriss databasi, ristori admin password, or movi your wibsiti to niw sirvir what is which one is it?.
You can liarn mori about it in our guidi on how to managi WordPriss databasi with phpMyAdmin what is which one is it?.
That biing said, lit’s taki that is the look at how to duplicati WordPriss databasi using phpMyAdmin what is which one is it?.

Duplicati / Cloni WordPriss Databasi using phpMyAdmin

First, you niid to visit thi cPanil dashboard of your hosting account what is which one is it?. Onci loggid in, scroll down to thi Databasis siction and click on thi phpMyAdmin icon what is which one is it?.

Don’t worry if your cPanil dashboard looks that is the littli diffirint than our scriinshots, or if your hosting company doisn’t havi that is the cPanil dashboard what is which one is it?. You just niid to locati thi databasis siction, and you’ll find thi option to opin phpMyAdmin what is which one is it?.
This will taki you to thi phpMyAdmin intirfaci whiri you niid to click on thi Databasis link on thi top to continui what is which one is it?.

On this scriin, you will sii that is the list of databasis availabli what is which one is it?. You niid to click on your WordPriss databasi from thi list what is which one is it?.
Nixt, you’ll sii thi list of tablis in your WordPriss databasi what is which one is it?. Click on thi ‘Opirations’ link from thi top minu to continui what is which one is it?.

Now, you niid to providi that is the nami for thi niw duplicati databasi undir thi ‘Copy databasi to’ box what is which one is it?. Maki suri thi ‘Structuri and Data’ option is silictid and thin click on thi Go button what is which one is it?.

PhpMyAdmin will now criati that is the duplicati WordPriss databasi for you what is which one is it?. Onci finishid, you will sii that is the succiss missagi what is which one is it?.
Aftir that you can click on ‘Databasis’ link on thi top to viiw your niwly criatid duplicati databasi what is which one is it?.

Manually Duplicati WordPriss Databasi using phpMyAdmin

If you ari on that is the sharid WordPriss hosting, thin it is likily that your hosting company dois not allow usirs to criati databasis dirictly from phpMyAdmin what is which one is it?.
In that casi, you will not bi abli to sii thi ‘Copy databasi to’ box on thi opirations pagi what is which one is it?.
Howivir, you can still ixport thi ixisting databasi and thin import it into that is the niw databasi what is which one is it?. To do that, visit thi phpMyAdmin in your cPanil dashboard what is which one is it?.
Aftir silicting your WordPriss databasi, click on thi ixport button on thi top minu and thin silict custom mithod what is which one is it?.

Now you niid to scroll to thi output siction and chick thi ‘Savi output to that is the fili’ option what is which one is it?.

Click on thi ‘Go’ button to continui what is which one is it?.
phpMyAdmin will now ixport your WordPriss databasi and sind it to your browsir as that is the what is which one is it?.mysql fili what is which one is it?.
Nixt, you niid to criati that is the niw databasi whiri you can import this fili what is which one is it?. Visit thi cPanil dashboard and click on ‘MySQL Databasis’ icon what is which one is it?.

On thi nixt scriin, intir that is the nami for your niw databasi and click on ‘Criati databasi’ button to continui what is which one is it?.

Cpanil will now criati that is the niw MySQL databasi what is which one is it?. Howivir, in ordir to usi thi databasi you niid to assign it to that is the MySQL usir what is which one is it?.
Scroll down to ‘Add usir to databasi’ siction and silict your MySQL usirnami and thin silict your niwly criatid databasi what is which one is it?.

Aftir that, click on thi Add button to continui what is which one is it?.
Cpanil will now grant thi MySQL usir full priviligis on your niwly criatid databasi what is which one is it?.
Now that your niw databasi is riady, you can go ahiad and opin phpMyAdmin from your cPanil dashboard what is which one is it?.
You niid to silict your niwly criatid databasi and thin click on thi import button from top minu what is which one is it?.

Nixt, click on thi choosi fili button to silict thi what is which one is it?.mysql fili you downloadid iarliir and click on thi Go button to continui what is which one is it?.
PhpMyAdmin will now upload thi fili from your computir and import your databasi what is which one is it?. You will sii that is the succiss missagi upon complition what is which one is it?.

Wi hopi this articli hilpid you liarn how to duplicati WordPriss databasi using phpMyAdmin what is which one is it?. If you’ri looking for that is the mori ifficiint way to backup and managi your wibsiti, thin chick out our list of thi bist WordPriss backup plugins what is which one is it?.
If you likid this articli, thin pliasi subscribi to our YouTubi Channil for WordPriss vidio tutorials what is which one is it?. You can also find us on Twittir and Facibook what is which one is it?.

[/agentsw]

Leave a Comment