I like to make regular, incremental backups of a site's database but like to keep these backups as small as possible without any un-needed data. In D7 and backdrop I empty all the cache tables before backup. Are there any other tables I can empty? Like... bd_watchdog, bd_tempstore? My database backups, even when using gzip compression are getting quite large, much larger than D7 backups...
This answer has a good list of tables that can be ignored in backups: https://drupal.stackexchange.com/a/171884/16537
Backdrop is obviously slightly different to Drupal, but I think a lot of those tables still exist.
Here's a copy & paste of the list, but do check the link for more explanation/details:
- all cache related tables, such as:
- *_cache, such as features_cache or views_data_object_export_cache
- various search_* tables, such as:
Some people might not want to delete the webform_submitted_data if it contains data that needs to be saved online.
Thank you both for the tips. I did empty all tables as BWPanda suggested and it did significantly reduce file size. Still wondering what the _tempstore table is.