Video Tutorials

Akeeba Backup for WordPress Excluding Large Files & Database Tables

Credits: Video Training produced by Brian Teeman

Transcript of this course

Click on any line below to get to the corresponding part of the video.

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 lets 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.