Support

Video Tutorials

Akeeba Backup for WordPress Excluding Large Files & Database Tables

Credits: Video Training produced by Brian Teeman


Transcript of this course

As your web site grows and becomes more complex, we might want to take advantage of some of the advanced features available in Akeeba Backup to exclude some data from the backup itself.

To begin with, let's look at the Database Tables exclusion. Here we can see listed all the tables that exist in the database.

Now, not all of these might be related to our WordPress web site. For example, I have the database tables for a phpBB site.

Akeeba Backup is very clever; if I click on this Exclude Non-Core table, it will go through the entire list of database tables and flag all the ones that are not part of the WordPres installation to be excluded from this backup.

As you can see, all of the phpBB tables have now been flagged to be excluded from the backup.

I can also mark some tables in a slightly different way by clicking here if I want to include the table but not include the contents of that table. For example, I do need the comments table but I don't need to backup the comments themselves.

If you want to see a list of all the tables that are going to be excluded, you can click here. We can see the tables that are going to be excluded from the backup and those tables that will be included but without their contents.

If you want to change one of the settings, click on the delete button to remove it from the exclusion.

Now that we've excluded the database tables that are not related to this WordPress web site, let's have a look at some of the files.

If we go back to our dashboard, we can see we have a Files & Directories exclusion as well. Over here we can see I have particularly large file which is an mp3 that I don't need to backup.

I am going to click on this icon to exclude that individual file.

Now in this site inside my uploads folder, I have a large number of images in multiple sizes. They're pretty big and I may not want to include those in my backup as I've got a copy of them elsewhere. If I click on this icon here, I can exclude all the uploads.

I could just skip the subdirectories by clicking here instead and keep the main one. But I am going to exclude the entire directory.

Again we can see a list of all the files that we've set to be excluded by clicking on the summary view button. You can see I've set it to exclude the uploads folder and the large mp3.

I can now return to the Control Panel and perform a new backup.

Any backup will now exclude those database tables that are not related to this WordPress web site AND those large uploads directories and files which I didn't want to include.

Cookies Notification - Action required

This website uses cookies to provide user authentication and improve your user experience. Please indicate whether you consent to our site placing these cookies on your device. You can change your preference later, from the controls which will be made available to you at the bottom of every page of our site.