Steps for creating a TYPO3 backup: Securing the TYPO3 database
Normally, you will have access to the TYPO3 database in some form or another, which you will receive from your provider. In individual cases, the views here may of course differ depending on the configuration of your host. The header of your database structure overview should include the following items:
You can click “OK” here. After a short time, a dialog box will open for saving the export file. You have now saved the entire database on your computer.
If you have exported the database as described above, all cache tables, the reference index (sys_refindex), and the table of all TYPO3 extensions from the repository (tx_extensionmanager_domain_model_extension: approx. 13MB) will also be included in this export. This means that the export may be much larger than necessary. This can then unnecessarily delay the re-import. If you select “Custom – show all possible options” under “Type of export” or “Export method,” you can omit these tables or export only the structure of these tables.
The following points should be activated/changed accordingly here
All database tables are selected by default under “Tables.” However, some tables are filled automatically by Typo3 (e.g., the cache tables) or can be updated in the backend with just a few simple steps.
be_sessions
For the backend login
cache_extbase_object, cache_extbase_object_tags, cache_hash, cache_hash_tags, cache_imagesizes, cache_imagesizes_tags, cache_pages, cache_pagesection, cache_pagesection_tags, cache_pages_tags, cache_rootline, cache_rootline_tags, cache_staticfilecache, cache_staticfilecache_tags, cache_treelist
Cache tables that are filled automatically. In older TYPO3 versions, these are also called cf_cache_...
fe_sessions (fe_session_data bei älteren TYPO3's
For the front-end login
Falls Sie "static_info_tables" installiert haben:
static_countries, static_country_zones, static_currencies, static_languages, static_territories
The tables can be updated manually in the extension.
sys_file_processedfile
All images, including those in the backend, that have been scaled by TYPO3. The corresponding files are usually located under “fileadmin/_processed_”. If you do not export the table, you should also empty the directory when re-importing.
sys_history, sys_log
Who did what in the TYPO3 backend, where and when; did any errors occur (sys_log)? Decide for yourself whether you still want to have the tables after a system crash. Maybe especially then?
sys_refindex
This table can be refreshed under “DB Check/Update Reference Index.”
tx_extensionmanager_domain_model_extension
This table is automatically updated when the list of extensions is updated under “Extensions.
tx_rsaauth_keys
Used for password encryption for logins – If a system is so defective that the database has to be restored, the table can also be refilled.
Your TYPO3 system may have other (cache) tables, or the entire “cache_...” tables may not exist because the presets (under “Administration Tools/Settings”) have file cache selected instead of database cache.
With newer versions of phpMyAdmin, you can now export tables completely, including data, in one step, and only the structure from others.
