Database

How to empty the WordPress trash automatically after a number of days on your website without a plugin

October 30, 2019 by admin Leave a Comment

On your WordPress website you may delete items like posts or pages and those items may go to the trash on there. This may help keep your database smaller on the website. You may want to have the trash automatically empty without using a plugin. You can then add this code to your functions.php file. You may want to backup your WordPress website before you make updates to that on there.

/**
 * Empty trash automatically
 *
 * @author WPSnacks.com
 * @link https://www.wpsnacks.com
 */
define('EMPTY_TRASH_DAYS', # );

You can then replace the # with the number of days you want WordPress to wait before it automatically empties the trash on there. Now if that works for you it would automatically empty the trash after the number of days you put on there.

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.

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.

How to install the UpdraftPlus WordPress Backup Plugin to your WordPress website

October 27, 2019 by admin Leave a Comment

If you have a WordPress website it is often a good idea to make backup the website often. This tutorial will walk you through how to install a popular WordPress backup plugin UpdraftPlus WordPress Backup Plugin from the WordPress plugin page. You may want to make a backup of your website before you install plugins like this one.

From the WordPress Admin you can click on plugins > add new in the left menu
In the search bar at the top right you can type in updraftplus in it
That should then bring up a list of plugins with updraftplus at the top of the list there
You can then click the install now button
Then you can click the activate button
Then you can click on settings > updraft plus backups in the left menu
From that page you can look through the different settings you have available and run the backup tool if you want.

You can do settings on the plugin to have it backup your website when you want it to and it can put the backup on your hosting server with ftp or even have it email it to you if you want. There are lots of settings you may want to try on it.

If you want to do a backup of your website files without using a plugin you can backup your website files manually through FTP on there. If you want to do a backup of your website database manually you can backup the database manually through PHPMyAdmin on there.

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