Support

Video Tutorials

Akeeba Backup for Joomla! 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, 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 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 tables 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.

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 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 so that their contents and any files in them will not to be backed up, such as the cache and temp, as we would not want to transfer those across to a new site.

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 the entire video directory. I can do the same for my downloads or I could just skip the subdirectories and keep the main one.

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.

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 downloads and videos directories which I decided 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.