{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"TYPO3 clear all caching tables","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/259 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"259\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.bash .de1, .bash .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.bash  {font-family:monospace;}\n.bash .imp {font-weight: bold; color: red;}\n.bash li, .bash .li1 {color: #DDD;}\n.bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.bash .kw1 {color: #000000; font-weight: bold;}\n.bash .kw2 {color: #c20cb9; font-weight: bold;}\n.bash .kw3 {color: #7a0874; font-weight: bold;}\n.bash .co0 {color: #666666; font-style: italic;}\n.bash .co1 {color: #800000;}\n.bash .co2 {color: #cc0000; font-style: italic;}\n.bash .co3 {color: #000000; font-weight: bold;}\n.bash .es1 {color: #000099; font-weight: bold;}\n.bash .es2 {color: #007800;}\n.bash .es3 {color: #007800;}\n.bash .es4 {color: #007800;}\n.bash .es5 {color: #780078;}\n.bash .es_h {color: #000099; font-weight: bold;}\n.bash .br0 {color: #7a0874; font-weight: bold;}\n.bash .sy0 {color: #000000; font-weight: bold;}\n.bash .st0 {color: #ff0000;}\n.bash .st_h {color: #ff0000;}\n.bash .nu0 {color: #000000;}\n.bash .re0 {color: #007800;}\n.bash .re1 {color: #007800;}\n.bash .re2 {color: #007800;}\n.bash .re4 {color: #007800;}\n.bash .re5 {color: #660033;}\n.bash span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"bash\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\"><span class=\"co0\">#!\/bin\/sh<\/span>\n<span class=\"co0\"># clear TYPO3 cache<\/span>\n<span class=\"co0\"># requires TYPO3 extension coreapi<\/span>\n<span class=\"kw1\">set<\/span> <span class=\"re5\">-e<\/span>\n&#160;\n<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>\n<span class=\"kw2\">su<\/span> <span class=\"re5\">-c<\/span> <span class=\"st0\">&quot;cd \/var\/www\/site\/htdocs &amp;&amp; .\/typo3\/cli_dispatch.phpsh extbase cacheapi:clearsystemcache&quot;<\/span>\\\n&#160; &#160;<span class=\"re5\">-s<\/span> <span class=\"sy0\">\/<\/span>bin<span class=\"sy0\">\/<\/span><span class=\"kw2\">sh<\/span>\\\n&#160; &#160;www-data\n<span class=\"kw2\">su<\/span> <span class=\"re5\">-c<\/span> <span class=\"st0\">&quot;cd \/var\/www\/site\/htdocs &amp;&amp; .\/typo3\/cli_dispatch.phpsh extbase cacheapi:clearallcaches&quot;<\/span>\\\n&#160; &#160;<span class=\"re5\">-s<\/span> <span class=\"sy0\">\/<\/span>bin<span class=\"sy0\">\/<\/span><span class=\"kw2\">sh<\/span>\\\n&#160; &#160;www-data<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/259\/rev-raw\/426c4cabbb5d7fd2d38abf3f9501902a60a6e586\/clear-caches.sh\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/259#clear-caches.sh\">clear-caches.sh<\/a>\n <\/div>\n<\/div>\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.sql .de1, .sql .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.sql  {font-family:monospace;}\n.sql .imp {font-weight: bold; color: red;}\n.sql li, .sql .li1 {color: #DDD;}\n.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.sql .kw1 {color: #993333; font-weight: bold;}\n.sql .co1 {color: #808080; font-style: italic;}\n.sql .coMULTI {color: #808080; font-style: italic;}\n.sql .es0 {color: #000099; font-weight: bold;}\n.sql .br0 {color: #66cc66;}\n.sql .sy0 {color: #66cc66;}\n.sql .st0 {color: #ff0000;}\n.sql .nu0 {color: #cc66cc;}\n.sql span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"sql\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n<\/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>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cache_md5params`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cache_treelist`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_hash`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_hash_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_imagesizes`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_imagesizes_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_pages`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_pagesection`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_pagesection_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_pages_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_rootline`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_cache_rootline_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_datamapfactory_datamap`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_datamapfactory_datamap_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_object`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_object_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_reflection`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_reflection_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_typo3dbbackend_queries`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_typo3dbbackend_queries_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_typo3dbbackend_tablecolumns`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_extbase_typo3dbbackend_tablecolumns_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_fluidcontent`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_fluidcontent_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_flux`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_flux_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_schemaker`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_schemaker_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_vhs_main`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_vhs_main_tags`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_vhs_markdown`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`cf_vhs_markdown_tags`<\/span>;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/259\/rev-raw\/426c4cabbb5d7fd2d38abf3f9501902a60a6e586\/clear.sql\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/259#clear.sql\">clear.sql<\/a>\n <\/div>\n<\/div>\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.sql .de1, .sql .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.sql  {font-family:monospace;}\n.sql .imp {font-weight: bold; color: red;}\n.sql li, .sql .li1 {color: #DDD;}\n.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.sql .kw1 {color: #993333; font-weight: bold;}\n.sql .co1 {color: #808080; font-style: italic;}\n.sql .coMULTI {color: #808080; font-style: italic;}\n.sql .es0 {color: #000099; font-weight: bold;}\n.sql .br0 {color: #66cc66;}\n.sql .sy0 {color: #66cc66;}\n.sql .st0 {color: #ff0000;}\n.sql .nu0 {color: #cc66cc;}\n.sql span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"sql\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n<\/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>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`sys_history`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`sys_log`<\/span>;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/259\/rev-raw\/426c4cabbb5d7fd2d38abf3f9501902a60a6e586\/log-history.sql\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/259#log-history.sql\">log-history.sql<\/a>\n <\/div>\n<\/div>\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.sql .de1, .sql .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.sql  {font-family:monospace;}\n.sql .imp {font-weight: bold; color: red;}\n.sql li, .sql .li1 {color: #DDD;}\n.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.sql .kw1 {color: #993333; font-weight: bold;}\n.sql .co1 {color: #808080; font-style: italic;}\n.sql .coMULTI {color: #808080; font-style: italic;}\n.sql .es0 {color: #000099; font-weight: bold;}\n.sql .br0 {color: #66cc66;}\n.sql .sy0 {color: #66cc66;}\n.sql .st0 {color: #ff0000;}\n.sql .nu0 {color: #cc66cc;}\n.sql span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"sql\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n<\/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>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_chashcache`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_pathcache`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_urldecodecache`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_urlencodecache`<\/span>;\n&#160;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/259\/rev-raw\/426c4cabbb5d7fd2d38abf3f9501902a60a6e586\/realurl.sql\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/259#realurl.sql\">realurl.sql<\/a>\n <\/div>\n<\/div>\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.sql .de1, .sql .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.sql  {font-family:monospace;}\n.sql .imp {font-weight: bold; color: red;}\n.sql li, .sql .li1 {color: #DDD;}\n.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.sql .kw1 {color: #993333; font-weight: bold;}\n.sql .co1 {color: #808080; font-style: italic;}\n.sql .coMULTI {color: #808080; font-style: italic;}\n.sql .es0 {color: #000099; font-weight: bold;}\n.sql .br0 {color: #66cc66;}\n.sql .sy0 {color: #66cc66;}\n.sql .st0 {color: #ff0000;}\n.sql .nu0 {color: #cc66cc;}\n.sql span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"sql\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n<\/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>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_uniqalias`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_uniqalias_cache_map`<\/span>;\n<span class=\"kw1\">TRUNCATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`tx_realurl_urldata`<\/span>;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/259\/rev-raw\/426c4cabbb5d7fd2d38abf3f9501902a60a6e586\/realurl2.sql\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/259#realurl2.sql\">realurl2.sql<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}