How to Duplicate WordPress Database using phpMyAdmin

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.

ALSO READ

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

GET STARTED

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...

DEALS

Bluehost Hosting

Get hosting for just $3.95 per month with Bluehost. Bluehost is an officially recommend WordPress host, and one of the most popular & reliable web hosts available.

POPULAR NOW

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 setup CloudFlare CDN for WordPress blog

In today's world website speed is a crucial element to getting good ranks on the web. Website speed also aids for indexing your site...

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 Delete Multiple Images in WordPress Media Gallery

Hey, guys today one of my friends asked me a question, How can I delete Multiple Images in WordPress? I replied, "It's very simple." Yeah,...

WP Super Cache Plugin: Best Settings & Configuration Guide

A cache plugin serves static contents to the visitor which improves page load speed. There are so many cache plugins available in the...

How to install Pure CWM Recovery on Xperia C

Hello readers, in my previous tutorial I have shared how to root Sony Xperia C. Let's consider you have successfully rooted your device. So...