How to duplicate a wordpress database using phpmyadmin

Want to make a copy of your WordPress database via phpMyAdmin? WordPress stores all site data in a MySQL database. Often a copy of the database is needed when transferring a site or when it is manually backed up. In this article I will tell you how easy it is to make a copy of the database through phpMyAdmin.

Click here : Website Designing Services UAE

How to easily duplicate a database

Why Use Phpmyadmin To Duplicate A Database

WordPress stores all site content in a database. Almost all WordPress hosting companies offer a database management system - MySQL. You can work with MySQL using command line tools, however it is not quite easy for beginners. That's why PhpMyAdmin is needed, because it offers a web interface for managing a MySQL database. With it, you can make a manual backup of the database ,  restore the administrator password,  or move the site to another server.

Having said all this, let's return to the main thing - how to duplicate a WordPress database using phpMyAdmin.

Duplication / Cloning Of a Wordpress Database Via Phpmyadmin

To get started, go to the cPanel control panel of your hosting account. Find the “Database” section and click on the phpMyAdmin icon.

Via the hosting panel, enter phpMyAdmin

Don’t worry if your cPanel control panel looks a little different than my screenshots, or if your hosting company does not have this panel at all. In that case, just go to the “Databases” section and find the “open phpMyAdmin” option or something similar . All modern hosting providers have access to databases from the control panel. So look, gentlemen.

After all these steps, the phpMyAdmin interface will appear, where in order to continue you need to click on the Databases link at the very top of the window.

Database selection

In the screen that appears, you will see a list of all available databases. Click on the necessary.

A list of tables appears in your WordPress database. To continue, click on the “Operations” link in the top menu.

Database Operations

Enter a name for the copy of the database in the box under “ Copy database to ”. Be sure to select the “Structure and Data” option and click the “Go” button.

Copy the entire database

PhpMyAdmin will start duplicating the WordPress database. At the end you will see a message about the successful completion of the process.

In order to view the created copy of the database at the top of the window, click on the "Databases" link.

Manual Copying a Wordpress Db through Phpmyadmin

If you use shared hosting, then it is quite possible that you do not have the ability to create a database directly from phpMyAdmin.

In this case, on the operations page, you will not see the box “Copy database to ...”.

However, you can export an existing database and then import it into a new database. To do this, go to phpMyAdmin in the cPanel toolbar.

Select the required WordPress database, in the main menu click on the “export” button and select the custom method - “custom”.

Database Export

Scrolled page to the "output" section ( "withdrawal") and check "option Save output to a file» ( « Save output to a file ") .

Save output to file

To continue the process, click on the “Go” button.

phpMyAdmin will start exporting the WordPress database and send it to your browser as a .mysql file.

Create a new database where you can import this file. Go to the cPanel toolbar and click on the "MySQLDatabases" icon.

Creating a new database through cPanel

In the next screen that appears, enter a name for the new database and click on the "Create database" button.

New database

Cpanel will create a new MySQL database. However, in order to start using it, you must assign it to the MySQL user.

To do this: Scroll the page to the “Add user to database” section and select your MySQL username. Then select the newly created database.

Adding a Database User

To continue the process, click on the “Add” button.

After that, Cpanel will provide MySQL users with all the privileges in the newly created database.

Now that a new database has been created, you can open phpMyAdmin through the cPanel toolbar.

Select the created database and click on the “Import” button in the main menu.

Import database

Then click on the “Select File” button and select the .mysql file that you previously downloaded, and click on the continue button - “Go”.

PhpMyAdmin will download this file from your computer and import it into the database. At the end you will see a message about the successful completion of the process.

Database import completed successfully

I hope this article helped you figure out how to make a copy of your WordPress database using phpMyAdmin.

If you need a more efficient way to backup and manage your site, check out the list of the best WordPress backup plugins .

If you liked this article, then please do not forget to like it.

For more information visit our website Digital Marketing Services in UAE