phpMyAdmin

Top 4 easy ways to make a backup of WordPress website files and database in 2019

October 27, 2019 by admin Leave a Comment

When you have a website on WordPress it is often a good idea to backup your website files and database often. I have written a few different posts with different methods on how to backup your WordPress website files and database. You can do it manually or with a plugin. The plugin may be the easiest of the options if you want to do that on there. This is my list of the top 4 ways to make a backup of your WordPress website files and database.

Now you can read up on a few different ways to make a backup of your WordPress website.

Disclosure: There are affiliate links on posts and throughout the website and if you use the links to make a purchase we may earn a commission from it. We link to these companies and their products because of the quality of the companies and not because of the commission we may receive from it.

Disclaimer: The information contained in this website is for general information purposes only and in no event will this website or its owners be liable for any losses or damages associated with your use of our website or content. We recommend that you make a backup of your website before you make updates to it. Click here to see our full Disclaimer.

How to manually backup your WordPress database in SQL using phpMyAdmin

October 26, 2019 by admin Leave a Comment

If you have a WordPress website you may want to it is often a good idea to backup your website database from time to time. Your WordPress database keeps the text and settings information for your website. You can do the database backup in SQL through phpMyAdmin if you want. When you are using phpMyAdmin or SQL you should be very careful when doing that as it is easy to make mistakes in there that may cause problems on your website or even to delete the website. That is one reason why it is good to have a backup. If you are not experienced with SQL or phpMyAdmin or if you do not feel comfortable using it to make the backup you may want to use a backup plugin instead.

To make a backup of your website database manually using a SQL program like phpMyAdmin you open the SQL program and then log onto your database using your SQL username and password details. If you do not know that you can usually find it in your hosting. Then you navigate to the database that your website is on. If you have multiple websites or databases in your hosting there may be more than one database listed. If there are more than one you need to find the right database. One way you can do this is click on each and click on the options table and that usually would list the website url. When you have the right database you go to the main database view page and click on check all to check all of the tables then click on export and then download the exported database then save that on your computer there.

This is only the website database. For WordPress you may want to backup the website files too.

How to delete unused post revisions from your WordPress Database

August 5, 2015 by admin 1 Comment

If you are like me, sometimes you update WordPress posts quite a lot, which can lead to a long list of Post Revisions for your posts. While this is very helpful if you need to go back to a recent version of the post, sometimes it can get cluttered.
[Read more…] about How to delete unused post revisions from your WordPress Database