Video Tutorials

Akeeba Backup for Joomla! (Core) Excluding Large Files and 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 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 Joomla web site. For example, here I had the database tables for a phpBB site.

Now Akeeba 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 this Joomla installation to be excluded from the backup.

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

I can also see several tables that also have been marked in a slightly different way. These are some of the core tables for our web site that are related to finder, tokens and sessions. In this case we do want to restore the database table but we don't want to transfer the contents. So the field has been flagged here for do not backup its contents.

If you want to see a list of all the tables that are going to be excluded you can click on Summary View. Here we can see them.

If you want to change one of the settings you can 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 Joomla web site let's have a look at some of the files.

If we go back to our Control Panel we can see we have a Files & Directories exclusion as well. We can see that some folders have already been marked not to be backed up. These are the cache, logs and temp. We would not want to transfer those across to a new site. Don't worry, when you restore your site from a backup Akeeba includes empty folders for these three.

Now in this site inside my images folder I have several large folders downloads and videos. They're pretty large and I don't 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 videos I can do the same for my downloads, or I could just skip the subdirectories and keep the main one, but I'm going to exclude the entire directory.

Over here we can see I have one particularly large file which is a pdf which I also don't need to backup. I am going to click on that icon to exclude that individual file.

Again we can see a list of all the files that we've set to be excluded by clicking on this icon. You can see I've set it to exclude the directory images/videos images/downloads and the file with that pdf.

I can now return to the Control Panel and perform a new backup and that will EXCLUDE those database tables that are not related to this Joomla web site. AND those large images and videos directories which I decided I didn't want to include.