WordPress Blog’s use MySQL Database to store whole information like your blog posts, comments, etc. If you’re a Professional Blogger then you’re constantly updating your blog with at least 4 blog posts a day and this data directly stored in MySQL database which you don’t want to lose at any condition, so it’s necessary for you to keep up the regular backups of your data to protect it from any loss or damage. Already I had covered a lot on the database from installing to deleting a database by using PHPMyAdmin. Now, this post focus on “how-to back-up the WordPress Database By Using PHPMyAdmin”.
Step1: Login in to Cpanel and click on PHPMyAdmin as shown below:
Step2: Now select the WordPress Database and click on the “Export” button as shown below:
Step3: Now click on “Select All” to choose all the tables located in the database.
Step4: Now click on SQL option on the right-hand side and save the file locally, you can choose the compression type and after choosing out click on the “Go” button to download it locally on your PC.
Step5: As soon as you click on the “Go” button, the browser will ask you to download the back-up. Select “Yes” to download or “No” not to download it.
Do share your ideas on how you back-up your WordPress blog. And, if you face any problem, then do let us know in the comments section?