WordPress How To’s – Duplicating the Database in PHP My Admin

WordPress How To’s – Duplicating the Database in PHP My Admin

Andy Holland

Are you looking to duplicate your WordPress database? You can do so using PHP My Admin! 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 PHP My Admin

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 PHP My Admin. 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 PHP My Admin. You will then be taken to the PHP My Admin 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. PHP My Admin 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 PHP My Admin

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 PHP My Admin 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 PHP My Admin from the cPanel dashboard. Choose this new database and import it. The next step is to select the mysql file and then PHP My Admin 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!

Andy Holland

Author Andy Holland

More posts by Andy Holland