Credits: Video Training produced by Brian Teeman
As your web site grows and becomes more complex, we might want to take advantage of some of the advanced features available in Akeeba Solo 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 Drupal web site. For example I have the database tables for a phpBB site.
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 the Drupal 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 have also been marked in a slightly different way. These are some of the core tables of our website that are related to cache. In this case, we do want to restore the database table but we dont want to transfer the contents. So the field has been flagged here to not backup its contents.
If you want to see a list of all the tables that are going to be excluded, you can click here Summary View.
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 the Akeeba Solo folder has been marked as not to be backed up, as we only want to backup our Drupal web site.
Now in this site inside my files folder I have several large folders, downloads and videos. They're pretty large and I don't 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 the enitre video directory. I could 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. You can see I've set it to exclude those two big directories and 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 Drupal web site, AND those large downloads and video directories which I decided I didn't want to include.