WordPress How To’s – Duplicating the Database in PHPmyAdmin

WordPress How To’s – Duplicating the Database in PHPmyAdmin

Andy Holland

Are you looking to duplicate your WordPress database? You can do so using PHPmyAdmin! With WordPress, all of your website data is stored in a My SQL database, but you may need to quickly duplicate this database and transfer it to another site, or just simply create a manual backup.

Duplicating Your WordPress Database Using PHPmyAdmin

All of your WordPress website content is stored in a database and most hosting companies use My SQL as the data management software. One of the easiest ways in which you can duplicate this database is using PHPmyAdmin. This is a web-based interface. It will not only back up your WordPress database but also restore admin passwords and can move websites to a new server.

The first thing that you will have to do is visit the cPanel dashboard on the hosting account. Here, you can visit the Databases section and hit PHPmyAdmin. You will then be taken to the PHPmyAdmin interface and here you can click on the Databases link. Once you have done this, you will find a database list available. Choose the WordPress database list. A list of tables in your WordPress database will then appear and you can choose ‘Operations.’ The next step is to give the fresh copied database a name in the ‘Copy database to’ box. Ensure that the ‘Structure and Data’ section is highlighted. PHPmyAdmin then creates a copy of your WordPress database for you.

Once you have done all of this, you’ll see a message saying you have been successful! Hit the ‘Databases’ link to see the newly copied database.

How to Manually Copy WordPress Data Using PHPmyAdmin

Users can not always create databases directly from php My Admin, particularly if you are using shared WordPress hosting. If this is the case, you won’t see the ‘Copy database to’ button. You can still, however, export the existing database and move it to a new database. Head on over to the PHPmyAdmin section of the cPanel dashboard. Choose the WordPress database and then hit the export and custom method. You can then go to the output section and choose the ‘Save output to a file’ option. It will then export the database and it will be delivered to your browser. Create a new database to import this file by creating a new MySQL database and assigning it to a user. You can then open up the PHPmyAdmin from the cPanel dashboard. Choose this new database and import it. The next step is to select the mysql file and then PHPmyAdmin will upload the file. It will then import the database!

Let us know how you get on with backing up your WordPress database in the comments below!