Backup/Restore mysql databases using mysqldump
Sometimes we want to have a dump of all our databases in mysql and restore it later to somewhere else or in the same server. here’s how... In your terminal:…
Excluding files and folders with tar
Excluding files/folders using tar is very straight forward. Assuming we have a directory tree similar to this in Linux -/home/cliper/ |--- folder/ |--- file1 |--- file2 |--- folder and we…
Get Magento’s database configuration
On Linux, make a php file anywhere in your filesystem while including the magento Mage file. <?php require_once "/home/cliper/magento/app/Mage.php"; Mage::app(); $config = Mage::getConfig()->getResourceConnectionConfig("default_setup"); $dbinfo = array(“host” => $config->host, “user” =>…
Rebuilt Magento Indexes in terminal with php-cli
For the past 6 months, had been doing a lot of work with Magento. I’ve notice that the more I know the whole thing, the more I don’t want…
Get the offset (index, array key) of an array in php
$fruits = array(0 => “apple”, 1 => “orange”, 2 => “lemon” ); foreach($fruits as $key => $fruit) { printf(“%s is in index %s”, $fruit, $key); }