TYPO3 clear all caching tables

raw

clear-caches.sh

1
2
3
4
5
6
7
8
9
10
11
12
#!/bin/sh
# clear TYPO3 cache
# requires TYPO3 extension coreapi
set -e
 
rm -rf /var/www/site/htdocs/typo3temp/*
su -c "cd /var/www/site/htdocs && ./typo3/cli_dispatch.phpsh extbase cacheapi:clearsystemcache"\
   -s /bin/sh\
   www-data
su -c "cd /var/www/site/htdocs && ./typo3/cli_dispatch.phpsh extbase cacheapi:clearallcaches"\
   -s /bin/sh\
   www-data
raw

clear.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
SET foreign_key_checks = 0;
TRUNCATE TABLE `cache_md5params`;
TRUNCATE TABLE `cache_treelist`;
TRUNCATE TABLE `cf_cache_hash`;
TRUNCATE TABLE `cf_cache_hash_tags`;
TRUNCATE TABLE `cf_cache_imagesizes`;
TRUNCATE TABLE `cf_cache_imagesizes_tags`;
TRUNCATE TABLE `cf_cache_pages`;
TRUNCATE TABLE `cf_cache_pagesection`;
TRUNCATE TABLE `cf_cache_pagesection_tags`;
TRUNCATE TABLE `cf_cache_pages_tags`;
TRUNCATE TABLE `cf_cache_rootline`;
TRUNCATE TABLE `cf_cache_rootline_tags`;
TRUNCATE TABLE `cf_extbase_datamapfactory_datamap`;
TRUNCATE TABLE `cf_extbase_datamapfactory_datamap_tags`;
TRUNCATE TABLE `cf_extbase_object`;
TRUNCATE TABLE `cf_extbase_object_tags`;
TRUNCATE TABLE `cf_extbase_reflection`;
TRUNCATE TABLE `cf_extbase_reflection_tags`;
TRUNCATE TABLE `cf_extbase_typo3dbbackend_queries`;
TRUNCATE TABLE `cf_extbase_typo3dbbackend_queries_tags`;
TRUNCATE TABLE `cf_extbase_typo3dbbackend_tablecolumns`;
TRUNCATE TABLE `cf_extbase_typo3dbbackend_tablecolumns_tags`;
TRUNCATE TABLE `cf_fluidcontent`;
TRUNCATE TABLE `cf_fluidcontent_tags`;
TRUNCATE TABLE `cf_flux`;
TRUNCATE TABLE `cf_flux_tags`;
TRUNCATE TABLE `cf_schemaker`;
TRUNCATE TABLE `cf_schemaker_tags`;
TRUNCATE TABLE `cf_vhs_main`;
TRUNCATE TABLE `cf_vhs_main_tags`;
TRUNCATE TABLE `cf_vhs_markdown`;
TRUNCATE TABLE `cf_vhs_markdown_tags`;
raw

log-history.sql

1
2
3
SET foreign_key_checks = 0;
TRUNCATE TABLE `sys_history`;
TRUNCATE TABLE `sys_log`;
raw

realurl.sql

1
2
3
4
5
6
SET foreign_key_checks = 0;
TRUNCATE TABLE `tx_realurl_chashcache`;
TRUNCATE TABLE `tx_realurl_pathcache`;
TRUNCATE TABLE `tx_realurl_urldecodecache`;
TRUNCATE TABLE `tx_realurl_urlencodecache`;
 
raw

realurl2.sql

1
2
3
4
TRUNCATE TABLE `tx_realurl_pathdata`;
TRUNCATE TABLE `tx_realurl_uniqalias`;
TRUNCATE TABLE `tx_realurl_uniqalias_cache_map`;
TRUNCATE TABLE `tx_realurl_urldata`;
Christian Weiske Christian Weiske
owner

History