By now, certain tables (TYPO3 cache tables, see full list below) have been excluded in our daily MySQL dumps created in ~/backup/
. If you are unaware of those excludes, this could lead to unexpected behaviour when restoring databases. Therefore, we analyzed the current usage and conclueded that we can safely remove the excludes in favour of exporting the full database. The exports will require slightly more diskspace (LZOP compression is used), but the reduced complexity in case of emergency actions do justify this.
New included TYPO3 tables (other applications are not affected):
- cache_extensions
- cache_hash
- cache_imagesizes
- cache_pages
- cache_pagesection
- index_fulltext
- index_grlist
- index_phash
- index_rel
- index_sections
- tx_realurl_errorlog
- sys_refindex
- cache_md5params
- cache_treelist
- cf_cache_hash
- cf_cache_hash_tags
- cf_cache_imagesizes
- cf_cache_imagesizes_tags
- cf_cache_pages
- cf_cache_pagesection
- cf_cache_pagesection_tags
- cf_cache_pages_tags
- cf_cache_rootline
- cf_cache_rootline_tags
- cf_extbase_datamapfactory_datamap
- cf_extbase_datamapfactory_datamap_tags
- cf_extbase_object
- cf_extbase_object_tags
- cf_extbase_reflection
- cf_extbase_reflection_tags
- cf_extbase_typo3dbbackend_queries
- cf_extbase_typo3dbbackend_queries_tags
- cf_extbase_typo3dbbackend_tablecolumns
- cf_extbase_typo3dbbackend_tablecolumns_tags
- cf_fluidcontent
- cf_fluidcontent_tags
- cf_flux
- cf_flux_tags
- cf_schemaker
- cf_schemaker_tags
- cf_vhs_main
- cf_vhs_main_tags
- cf_vhs_markdown
- cf_vhs_markdown_tags
Reference #990