How to Download WordPress Database Backup with phpMyAdmin

How to Download WordPress Database Backup with phpMyAdmin

How to Download WordPress Database Backup with phpMyAdmin-: Your WordPress Hosting provider either provide Automatic Backup or Manual backup depends upon your hosting plan. It is always recommended to take manual backup on an equal interval of time if your hosting provider doesn’t provide automated backup. In this post, I will explain How to download your WordPress website database using phpMyadmin.

How to Download WordPress Database Backup with phpMyAdmin-:

In my previous post, I have given depth information about phpMyAdmin. phpMyAdmin is a free open source tool available via your browser that is used to handle the administration of MySQL or MariaDB. It can be used for all sorts of different operations, such as migrating databases, managing tables, indexes, and executing SQL statements.

If you want to do any local development on your WordPress website you can download you’re My SQL Database. The following is a very simple version of Backing Up Your Database. Once you have discovered how to access your site’s phpMyAdmin, follow these simple instructions.

Step.1-: Click on Databases in your phpMyAdmin panel. (It may not be necessary to do this, depending on your version of phpMyAdmin)

How to Download WordPress Database Backup with phpMyAdmin

Step.2-: You may have several databases. Click the one that holds your WordPress data, the database you created when you installed WordPress. (In older versions this may be done through a pull-down menu.)

Step.3-: Below is a picture of the default tables in the Structure view tab. You may have more tables — this would happen if you have any statistics plugins or Anti-Spam plugins.

How to Download WordPress Database Backup with phpMyAdmin

Step.4-: Click Export.
There are two methods to export, Quick and Custom; if you choose Custom, follow these steps:

Step.5-: Select all the tables.

Step.6-: In the Output section check Save output to a file and select None for Compression. (If your database is very large use a compression method)

Step.7-: Select SQL from the Format drop-down menu.

Step.8-: Check “Add DROP TABLE”: this can be useful for overwriting an existing database.

Step.9-: Check “IF NOT EXISTS”: this prevents errors during restores if the tables are already there.

Step.10-: Click Go. The data will now be saved into your computer.

Thanks for reading…“Pardon my grammar, English is not my native tongue.”

If you like my work, Please Share on Social Media! You can Follow WP knol on FacebookTwitterPinterest and YouTube for latest updates. You may Subscribe to WP Knol Newsletter to get latest updates via Email. You May also Continue Reading my Recent Posts Which Might Interest You.

About Amar Patel 263 Articles
Hi, I am Amar Patel from India. Founder, Author and Administrator of wpknol.com. I am a Simple Average Man who Loves life and Love living life.Professionally I am a Mechanical Engineer. Apart from my Job, I Love to write the things around WordPress WordPress CMS.