TYPO3 Cache Clear Script

typo3.rb

set :typo3_maindir, '/html/typo3/'
set :php_cli, '/usr/local/bin/php_cli'
task :typo3_flushcache do
queue %[echo "------> TYPO3: flushing cache"];
queue %[cd #{typo3_maindir} && rm -R typo3temp/*];
queue %[
cd #{typo3_maindir} && #{php_cli} -r '
$GLOBALS["TYPO3_CONF_VARS"] = require(dirname(__FILE__)."/typo3conf/LocalConfiguration.php");
$ac = dirname(__FILE__)."/typo3conf/AdditionalConfiguration.php";
if(file_exists($ac)){
include($ac);
}
$db = $GLOBALS["TYPO3_CONF_VARS"]["DB"];
$mysql = mysql_connect($db["host"],$db["username"],$db["password"]);
if(!$mysql){
die("oh crap");
}
mysql_select_db($db["database"],$mysql);
$queries = array(
"TRUNCATE `cf_cache_hash`",
"TRUNCATE `cf_cache_hash_tags`",
"TRUNCATE `cf_cache_pages`",
"TRUNCATE `cf_cache_pagesection`",
"TRUNCATE `cf_cache_pagesection_tags`",
"TRUNCATE `cf_cache_pages_tags`",
"TRUNCATE `cf_cache_rootline`",
"TRUNCATE `cf_extbase_datamapfactory_datamap`",
"TRUNCATE `cf_extbase_datamapfactory_datamap_tags`",
"TRUNCATE `cf_extbase_object`",
"TRUNCATE `cf_extbase_object_tags`",
"TRUNCATE `cf_extbase_reflection`",
"TRUNCATE `cf_extbase_reflection_tags`",
"TRUNCATE `cf_extbase_typo3dbbackend_queries`",
"TRUNCATE `cf_extbase_typo3dbbackend_queries_tags`",
"TRUNCATE `cf_extbase_typo3dbbackend_tablecolumns`",
"TRUNCATE `cf_extbase_typo3dbbackend_tablecolumns_tags`",
);
foreach($queries as $query){
echo $query."\n";
if(!mysql_query($query)){
die("well, crap " . mysql_error());
}
}
mysql_close($mysql);
'
]
end;