Tiago P Dantas tiagones
tiagones
/ magento-db-cleanup.sql
Created
July 25, 2016 13:57
— forked from therouv/magento-db-cleanup.sql
DB cleanup script for Magento with some common database tables.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET FOREIGN_KEY_CHECKS=0; | |
| -- Customers | |
| TRUNCATE `customer_entity`; | |
| TRUNCATE `customer_entity_datetime`; | |
| TRUNCATE `customer_entity_decimal`; | |
| TRUNCATE `customer_entity_int`; | |
| TRUNCATE `customer_entity_text`; | |
| TRUNCATE `customer_entity_varchar`; |
tiagones
/ cleanup.php
Created
August 28, 2015 15:42
— forked from mkdizajn/magento var and mysql log cleanup script
Magneto Log & Cache Maintenance Script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // cleanup.php?clean=var | |
| // cleanup.php?clean=log | |
| $xml = simplexml_load_file('./app/etc/local.xml', NULL, LIBXML_NOCDATA); | |
| $db['host'] = $xml->global->resources->default_setup->connection->host; | |
| $db['name'] = $xml->global->resources->default_setup->connection->dbname; | |
| $db['user'] = $xml->global->resources->default_setup->connection->username; |
tiagones
/ tinydump.php
Last active
August 29, 2015 14:05
— forked from ceckoslab/tinydump
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| define('DS', DIRECTORY_SEPARATOR); | |
| function _getExtractSchemaStatement($sqlFileName, $db) | |
| { | |
| $dumpSchema = 'mysqldump' . ' '; | |
| $dumpSchema .= '--no-data' . ' '; | |
| $dumpSchema .= '-u ' . $db['user'] . ' '; | |
| $dumpSchema .= '-p' . $db['pass'] . ' '; | |
| $dumpSchema .= '-h ' . $db['host'] . ' '; |
tiagones
/ local.xml
Created
July 23, 2014 23:30
— forked from Maksold/local.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0"?> | |
| <layout> | |
| <default> | |
| <!--Root/Default Layouts--> | |
| <reference name="root"> | |
| <!--Appending Block--> | |
| <block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/> | |
| </reference> | |
| <!--CSS and JS Files--> |