{"id":1185,"date":"2014-12-22T09:39:10","date_gmt":"2014-12-22T09:39:10","guid":{"rendered":"http:\/\/www.bay20.com\/?p=1185"},"modified":"2025-05-09T11:05:31","modified_gmt":"2025-05-09T05:20:31","slug":"magneto-log-cache-wartungsskript","status":"publish","type":"post","link":"https:\/\/www.bay20.com\/de\/magneto-log-cache-wartungsskript\/","title":{"rendered":"Magento Log &#038; Cache Wartung Script"},"content":{"rendered":"<p>Erstellen Sie eine Datei namens <strong>cleaner.php<\/strong> und f\u00fcgen Sie den folgenden Code hinzu:<\/p>\n<pre class=\"lang-php prettyprint prettyprinted\"><em>&lt;?php <\/em>\n\n<em>switch($_GET['clean']) {<\/em>\n\n<em>case 'log':<\/em>\n<em> clean_log_tables();<\/em>\n<em> break;<\/em>\n<em> case 'var':<\/em>\n<em> clean_var_directory();<\/em>\n<em> break;<\/em>\n<em> }<\/em>\n\n<em>function clean_log_tables() {<\/em>\n<em> $xml = simplexml_load_file('.\/app\/etc\/local.xml', NULL, LIBXML_NOCDATA);<\/em>\n\n<em>if(is_object($xml)) {<\/em>\n<em> $db['host'] = $xml-&gt;global-&gt;resources-&gt;default_setup-&gt;connection-&gt;host;<\/em>\n<em> $db['name'] = $xml-&gt;global-&gt;resources-&gt;default_setup-&gt;connection-&gt;dbname;<\/em>\n<em> $db['user'] = $xml-&gt;global-&gt;resources-&gt;default_setup-&gt;connection-&gt;username;<\/em>\n<em> $db['pass'] = $xml-&gt;global-&gt;resources-&gt;default_setup-&gt;connection-&gt;password;<\/em>\n<em> $db['pref'] = $xml-&gt;global-&gt;resources-&gt;db-&gt;table_prefix;<\/em>\n\n<em>$tables = array(<\/em>\n<em> 'aw_core_logger',<\/em>\n<em> 'dataflow_batch_export',<\/em>\n<em> 'dataflow_batch_import',<\/em>\n<em> 'log_customer',<\/em>\n<em> 'log_quote',<\/em>\n<em> 'log_summary',<\/em>\n<em> 'log_summary_type',<\/em>\n<em> 'log_url',<\/em>\n<em> 'log_url_info',<\/em>\n<em> 'log_visitor',<\/em>\n<em> 'log_visitor_info',<\/em>\n<em> 'log_visitor_online',<\/em>\n<em> 'index_event',<\/em>\n<em> 'report_event',<\/em>\n<em> 'report_viewed_product_index',<\/em>\n<em> 'report_compared_product_index',<\/em>\n<em> 'catalog_compare_item',<\/em>\n<em> 'catalogindex_aggregation',<\/em>\n<em> 'catalogindex_aggregation_tag',<\/em>\n<em> 'catalogindex_aggregation_to_tag'<\/em>\n<em> );<\/em>\n\n<em>mysql_connect($db['host'], $db['user'], $db['pass']) or die(mysql_error());<\/em>\n<em> mysql_select_db($db['name']) or die(mysql_error());<\/em>\n\n<em>foreach($tables as $table) {<\/em>\n<em> @mysql_query('TRUNCATE `'.$db['pref'].$table.'`');<\/em>\n<em> }<\/em>\n<em> echo \"All log files have been cleaned.\";<\/em>\n<em> } else {<\/em>\n<em> exit('Unable to load local.xml file');<\/em>\n<em> }<\/em>\n<em> }<\/em>\n\n<em>function clean_var_directory() {<\/em>\n<em> $dirs = array(<\/em>\n<em> 'downloader\/.cache\/',<\/em>\n<em> 'downloader\/pearlib\/cache\/*',<\/em>\n<em> 'downloader\/pearlib\/download\/*',<\/em>\n<em> 'media\/css\/',<\/em>\n<em> 'media\/css_secure\/',<\/em>\n<em> 'media\/import\/',<\/em>\n<em> 'media\/js\/',<\/em>\n<em> 'var\/cache\/',<\/em>\n<em> 'var\/locks\/',<\/em>\n<em> 'var\/log\/',<\/em>\n<em> 'var\/report\/',<\/em>\n<em> 'var\/session\/',<\/em>\n<em> 'var\/tmp\/'<\/em>\n<em> );<\/em>\n\n<em>foreach($dirs as $dir) {<\/em>\n<em> exec('rm -rf '.$dir);<\/em>\n<em> }<\/em>\n<em> echo \"All var files have been cleaned.\";<\/em>\n<em> }<\/em>\n\n<em>?&gt;<\/em><\/pre>\n<p>Speichern Sie diese Datei im Stammverzeichnis Ihres Magento-Verzeichnisses.<\/p>\n<p>Sie k\u00f6nnen diese Datei ausf\u00fchren, indem Sie die URL direkt in Ihrem Webbrowser aufrufen, z. B:<\/p>\n<pre class=\"lang-php prettyprint prettyprinted\"><strong>http:\/\/yourdomain.com\/cleaner.php?clean=log<\/strong>\n\n<strong>http:\/\/yourdomain.com\/cleaner.php?clean=var<\/strong><\/pre>\n<p>ODER Sie k\u00f6nnen einen Cron-Job f\u00fcr diesen Zweck einrichten. \u00d6ffnen Sie <strong>cPanel<\/strong>, gehen Sie zu <strong>Cron Jobs-&gt;Add New Cron Job<\/strong>. Stellen Sie den Cron-Job so ein, dass er <strong>einmal am Tag<\/strong> ausgef\u00fchrt wird, und f\u00fcgen Sie den folgenden <strong>Befehl<\/strong> hinzu:<\/p>\n<pre class=\"lang-php prettyprint prettyprinted\"><strong>php -f \/home\/&lt;yourhostname&gt;\/cleaner.php?clean=log<\/strong><\/pre>\n<p>Wiederholen Sie dieselben Schritte, aber \u00e4ndern Sie die Dropdown-Liste <strong>Gemeinsame Einstellungen<\/strong> auf <strong>1 und 15 (0 0 1,15 * *)<\/strong> und f\u00fcgen Sie den folgenden <strong>Befehl<\/strong> hinzu:<\/p>\n<pre class=\"lang-php prettyprint prettyprinted\"><strong>php -f \/home\/&lt;yourhostname&gt;\/cleaner.php?clean=var<\/strong><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Create a file called cleaner.php and add the following code to it:<\/p>\n","protected":false},"author":1,"featured_media":1493,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40],"tags":[],"class_list":["post-1185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts\/1185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/comments?post=1185"}],"version-history":[{"count":9,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts\/1185\/revisions"}],"predecessor-version":[{"id":16884,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts\/1185\/revisions\/16884"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/media\/1493"}],"wp:attachment":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/media?parent=1185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/categories?post=1185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/tags?post=1185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}