How to Duplicate WordPress Database using phpMyAdmin

Join InfoPhilic Community!

Let's build a community to help & encourage each other to grow!

In computing, Database refers to an organized set that store and organize data. WordPress is written using PHP as its scripting language and MySQL as its database management system. MySQL is a software used to create databases, store and get data when requested.

All WordPress hosting providers offer MySQL database. Sometimes you need to create manual backups or transfer a website. At both situations, you prefer cloning a WordPress database. Not only these, there are various situations where you may need to copy your WordPress database.

Before moving further, I recommend keeping backup and manage your website. Check out our list of the best WordPress backup plugins.

phpMyAdmin is the most popular free and open source tool that handles MySQL administration. So, you can use phpMyAdmin to manually backup your WordPress database, restore admin password, or move your website to the new server.

Duplicate WordPress Database using phpMyAdmin:

  • Login to cPanel dashboard of your hosting account.
  • Select Databases section and click phpMyAdmin icon. A phpMyAdmin interface will appear to you.
  • Now, click on Databases on the top.

A list of Databases will appear from which you have to select your WordPress database.

 Duplicate WordPress Database using phpMyAdmin

  • A list of tables in your DataBase will appear.
  • If you have multiple databases, then you must select the one you want to copy.
  • Now click on Operation from the top menu.
  • Provide a valid name for duplicating database into Copy database to box.
  • Ensure you have selected Structure and Data option.
  • Click Go.

PhpMyAdmin will now create a duplicate WordPress database. Once done, it will display a message box with success message.

How to Manually Duplicate WordPress Database using phpMyAdmin?

There is another way for duplicate WordPress database. Yes, you can manually create a duplicate database using phpMyAdmin. This option will be especially helpful for those, who use WordPress shared hosting.

Most often, WordPress shared hosting provider does not allow users to create databases directly from phpMyAdmin. Thus, users cannot copy a database to’ box on the operations page.

Export Database

At such condition, follow these steps:

export database using phpmyadmin

  • Visit the phpMyAdmin from cPanel.
  • Select your WordPress database.
  • Now select Export button from the top menu.
  • It will ask you to choose either Custom or Quick exporting method. Select Quick one.
  • Click Go.

If you want custom export then choose Custom then.

export database using phpmyadmin custom option

  • Scroll down to the Output section.
  • Here you to select the ‘Save output to a file’ option. Click Go.

phpMyAdmin will export your database and send to your browser in .mysql file format.

Import Database

Next task you have to do is creating a new database to import this exported database. To do so,

  • Go to cPanel dashboard and click on ‘MySQL Databases’.
    cpanel MySQL databases
  • A screen will appear, where you have to insert a name for your new database.

    Create Database using cPanel
    Create Database using cPanel
  • Click Create database button.

A new MySQL database will be created.

create database user in cPanel
create database user in cPanel

  • Now assign a MySQL user. To do so, go to Add user to database section.
  • Select your MySQL username and select your newly created database.
  • Click Add.

Your database is ready to use now.

  • Goto phpMyAdmin
  • Now Select your database and click on Import from the top menu.
  • Click on the choose file button to select the .mysql file you downloaded.
  • Click on Go.

PhpMyAdmin will now import your database. Once done, you will receive a success message.

So, this is how you can duplicate WordPress database by using phpMyAdmin. I hope, this guide helped you best in cloning your WordPress database.

Subscribe to our newsletter

To be updated with all the latest news, offers and special announcements.

Comment Policy: Your words are your own, so be nice and helpful if you can. Please, only use your real name and limit the amount of links submitted in your comment. We accept clean XHTML in comments, but don't overdo it please.


Please enter your comment!
Please enter your name here


Start WordPress Blog: Ultimate Guide For Beginners

Here is our step by step guide for beginners to start a WordPress blog.

Top 6 Best WordPress Theme Frameworks

There are many websites themes which are created by using a framework. Likewise, WordPress Theme frameworks also becoming so popular. The framework allows you...

The Most Essential WordPress Plugins

Here, I have listed some excellent plugins which will surely add more features and new functionality to your WordPress blog.

Tips to Speed Up WordPress Performance

Here, I am sharing some tips to speed up WordPress performance. All you need to modify .htaccess file on your server and add some plugins.

The Ultimate Guide to Harden WordPress Security

Learn how to improve WordPress security. Here are some basic security concepts that will help you to harden WordPress security.

How to Setup CloudFlare Free SSL for WordPress Blog

Google has announced that they will count HTTPS as a ranking factor which means if you using HTTPS you will get a higher position...



GET 30 Days Free.


Get almost 100% PageSpeed on Newspaper theme

The newspaper theme is the most popular premium theme for a self-hosted WordPress blog. The theme is developed by team tagDiv. You...

How to Remove jQuery Migrate in WordPress?

jQuery Migrate greatly simplifies the process of moving older jQuery code to a higher jQuery version by identifying deprecated features. It then restores deprecated...

How to Auto-Improve Server Response Time

Obtaining good user experience also includes fast page speed, less server response time and much more. People have different expectations of response times. For...

How To Reduce Admin-Ajax Server Load In WordPress

To increase better user experience, we always end up by increasing site speed. After clicking a website link seems like a simple thing. But...

How To Add Your New Site To Google Webmaster Tools

Googe Webmaster tools offered by the Google. It allows you to check how your website seen by robots and crawlers. You get the power...

How to configure WP-Rocket plugin for WordPress site

When it comes to optimizing your website, the role of caching in WordPress can never be underestimated. What exactly is caching all about?...