How to backup WordPress database with phpmyAdmin – No Plugins

Those who have been reading this blog must have read an umpteen number of times that I advocate the use of plugins only and only when you actually require them. Plugins if not required should be disabled or uninstalled as it helps load your web pages faster.  Now I come to the safety part. I won’t and I don’t have Top 10 or Top 5 ways to protect your blog. I just have to two -

1. backup your MySQL database and
2. backup your WordPress files.

If you know the difference between the two, cool enough. If not, don’t worry. Today, I shall be writing about the 1st way to protect your wordpress site/blog.

Requirements:

1. No coding or technical knowledge (this is to just assure you that this backup method is as easy as writing ABC. So have fun!)
2. cPanel Hosting (most of the hosting companies across the world provide cPanel web hosting.
3. phpMyAdmin program (it shall be available in your cPanel under ‘Databases’)

Let’s Start then:

Step 1:

Log in to phpMyAdmin from your cPanel.

Step 2:

On the utmost left side, you shall find a list of all the databases for each of your websites/blogs. Click the name of the database that you want to backup. If you have more than one databases in the list and are not sure which one is for your website/blog, open your wp-config.php file and find it out.

Step 3:

Step 4:

Note: If your same database is  used by other programs too, only select those tables that correspond to your wordpress blog/site. You can identify them easily as they begin with  ”wp_” or the ‘table_prefix’ you have specified in your ‘wp-config.php‘ file.

Step 5:

• Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
• Add IF NOT EXISTS
• Add AUTO_INCREMENT
• Enclose table and field names with backquotes

Step 6:

Under the ‘Save as File’ box, click ‘Go’ button. A .sql file shall be downloaded on your machine.

In a nutshell, this is how the screen will look before you export the database:

Did it help? Do inform me.