rich1.0phorkiehttps://p.cweiske.de/TYPO3 clear all caching tablesChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/259 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="259">
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.bash .de1, .bash .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.bash {font-family:monospace;}
.bash .imp {font-weight: bold; color: red;}
.bash li, .bash .li1 {color: #DDD;}
.bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.bash .kw1 {color: #000000; font-weight: bold;}
.bash .kw2 {color: #c20cb9; font-weight: bold;}
.bash .kw3 {color: #7a0874; font-weight: bold;}
.bash .co0 {color: #666666; font-style: italic;}
.bash .co1 {color: #800000;}
.bash .co2 {color: #cc0000; font-style: italic;}
.bash .co3 {color: #000000; font-weight: bold;}
.bash .es1 {color: #000099; font-weight: bold;}
.bash .es2 {color: #007800;}
.bash .es3 {color: #007800;}
.bash .es4 {color: #007800;}
.bash .es5 {color: #780078;}
.bash .es_h {color: #000099; font-weight: bold;}
.bash .br0 {color: #7a0874; font-weight: bold;}
.bash .sy0 {color: #000000; font-weight: bold;}
.bash .st0 {color: #ff0000;}
.bash .st_h {color: #ff0000;}
.bash .nu0 {color: #000000;}
.bash .re0 {color: #007800;}
.bash .re1 {color: #007800;}
.bash .re2 {color: #007800;}
.bash .re4 {color: #007800;}
.bash .re5 {color: #660033;}
.bash span.xtra { display:block; }
</style><div class="code"><table class="bash"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
</pre></td><td class="de1"><pre class="de1"><span class="co0">#!/bin/sh</span>
<span class="co0"># clear TYPO3 cache</span>
<span class="co0"># requires TYPO3 extension coreapi</span>
<span class="kw1">set</span> <span class="re5">-e</span>
 
<span class="kw2">rm</span> <span class="re5">-rf</span> <span class="sy0">/</span>var<span class="sy0">/</span>www<span class="sy0">/</span>site<span class="sy0">/</span>htdocs<span class="sy0">/</span>typo3temp<span class="sy0">/*</span>
<span class="kw2">su</span> <span class="re5">-c</span> <span class="st0">"cd /var/www/site/htdocs && ./typo3/cli_dispatch.phpsh extbase cacheapi:clearsystemcache"</span>\
   <span class="re5">-s</span> <span class="sy0">/</span>bin<span class="sy0">/</span><span class="kw2">sh</span>\
   www-data
<span class="kw2">su</span> <span class="re5">-c</span> <span class="st0">"cd /var/www/site/htdocs && ./typo3/cli_dispatch.phpsh extbase cacheapi:clearallcaches"</span>\
   <span class="re5">-s</span> <span class="sy0">/</span>bin<span class="sy0">/</span><span class="kw2">sh</span>\
   www-data</pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/259/rev-raw/426c4cabbb5d7fd2d38abf3f9501902a60a6e586/clear-caches.sh" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/259#clear-caches.sh">clear-caches.sh</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">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
</pre></td><td class="de1"><pre class="de1"><span class="kw1">SET</span> foreign_key_checks <span class="sy0">=</span> <span class="nu0">0</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cache_md5params`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cache_treelist`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_hash`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_hash_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_imagesizes`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_imagesizes_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_pages`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_pagesection`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_pagesection_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_pages_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_rootline`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_cache_rootline_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_datamapfactory_datamap`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_datamapfactory_datamap_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_object`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_object_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_reflection`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_reflection_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_typo3dbbackend_queries`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_typo3dbbackend_queries_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_typo3dbbackend_tablecolumns`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_extbase_typo3dbbackend_tablecolumns_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_fluidcontent`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_fluidcontent_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_flux`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_flux_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_schemaker`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_schemaker_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_vhs_main`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_vhs_main_tags`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_vhs_markdown`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`cf_vhs_markdown_tags`</span>;</pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/259/rev-raw/426c4cabbb5d7fd2d38abf3f9501902a60a6e586/clear.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/259#clear.sql">clear.sql</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
</pre></td><td class="de1"><pre class="de1"><span class="kw1">SET</span> foreign_key_checks <span class="sy0">=</span> <span class="nu0">0</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`sys_history`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`sys_log`</span>;</pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/259/rev-raw/426c4cabbb5d7fd2d38abf3f9501902a60a6e586/log-history.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/259#log-history.sql">log-history.sql</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
</pre></td><td class="de1"><pre class="de1"><span class="kw1">SET</span> foreign_key_checks <span class="sy0">=</span> <span class="nu0">0</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_chashcache`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_pathcache`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_urldecodecache`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_urlencodecache`</span>;
 </pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/259/rev-raw/426c4cabbb5d7fd2d38abf3f9501902a60a6e586/realurl.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/259#realurl.sql">realurl.sql</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
</pre></td><td class="de1"><pre class="de1"><span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_pathdata`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_uniqalias`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_uniqalias_cache_map`</span>;
<span class="kw1">TRUNCATE</span> <span class="kw1">TABLE</span> <span class="st0">`tx_realurl_urldata`</span>;</pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/259/rev-raw/426c4cabbb5d7fd2d38abf3f9501902a60a6e586/realurl2.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/259#realurl2.sql">realurl2.sql</a>
</div>
</div>
</div>