Skip to content

Instantly share code, notes, and snippets.

View MagePsycho's full-sized avatar

magepsycho MagePsycho

View GitHub Profile
@MagePsycho
MagePsycho / mage2-codebase-database-backup.sh
Last active May 29, 2018 03:58
Shell Script: Magento2 Database + Codebase Backup. More - http://www.blog.magepsycho.com/
#!/bin/bash
#
# Script to backup Magento2 Codebase + Database
#
# @author Raj KB <magepsycho@gmail.com>
# @website http://www.magepsycho.com
# @version 0.1.0
# UnComment it if bash is lower than 4.x version
@MagePsycho
MagePsycho / dump-all-dbs.sh
Last active October 6, 2017 06:44
MySQL: Dump all databases in a localhost
#! /bin/bash
TIMESTAMP=$(date +"%F")
BACKUP_DIR="/home/rajendra"
MYSQL=/usr/bin/mysql
MYSQL_USER="root"
MYSQL_PASSWORD="mys123"
MYSQLDUMP=/usr/bin/mysqldump
mkdir -p "$BACKUP_DIR/mysql-dump"
@MagePsycho
MagePsycho / .gitignore
Created August 28, 2017 20:18
Magento 1: Gitignore
# General web stuff
#/.htaccess
/robots.txt
/sitemap.xml
# Dynamic Magento data
/var/*
/media/catalog/product/cache/*
/media/tmp/
/media/js/*
@MagePsycho
MagePsycho / dynamic-table.sql
Last active August 7, 2017 18:52
MySQL: Dynamic Table + SQL
-- @author Raj KB
-- @website http://blog.magepsycho.com
SET @STORE_ID = 7;
SET @CATALOG_FLAT_TABLE = CONCAT('catalog_product_flat_', @STORE_ID);
SET @QUERY = CONCAT('SELECT * FROM ', @CATALOG_FLAT_TABLE, ' LIMIT 10');
PREPARE stmt FROM @QUERY;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
@MagePsycho
MagePsycho / magento2-useful-commands.md
Created June 5, 2017 18:06
Magento2 - Useful Commands

Collect translation from Module: mage2 i18n:collect-phrases --output="app/code/MagePsycho/RedirectPro/i18n/en_US.csv" app/code/MagePsycho/RedirectPro/

@MagePsycho
MagePsycho / bash-alias-toggle-php-xdebug.sh
Last active March 28, 2017 15:17
Toggle PHP XDebug in Ubuntu
phpToggleXdebug() {
case $1 in
on)
[ -f /etc/php5/mods-available/xdebug.ini.deactivated ] && sudo mv /etc/php5/mods-available/xdebug.ini.deactivated /etc/php5/mods-available/xdebug.ini
sudo service php5-fpm restart
sudo service nginx restart
;;
off)
[ -f /etc/php5/mods-available/xdebug.ini ] && sudo mv /etc/php5/mods-available/xdebug.ini /etc/php5/mods-available/xdebug.ini.deactivated
sudo service php5-fpm restart

Magento Code Snippets

Download extension manually using mage

./mage config-set preferred_state stable
./mage clear-cache
./mage sync
./mage download community Module_Name
<?php
/**
* Generates data with ready-to-edit CSV for magento translation
*
* A handy tool that generates CSV data for magento theme translation
* You can set the $mode to:
* a) either write that data to translate.csv at path you specify,
* b) or just to dump that data in browser for you to copy and use (default).
* In the write mode it appends new data to translate.csv thus you dont
@MagePsycho
MagePsycho / Data.php
Created March 28, 2016 18:36
Magento 2 Custom Logger - 2nd Approach
<?php
// File: app/code/MagePsycho/Helper/Data.php
// Usage: MagePsycho\Demo\Helper\Data::log($message)
namespace MagePsycho\Demo\Helper;
class Data extends \Magento\Framework\App\Helper\AbstractHelper
{
/**
@MagePsycho
MagePsycho / Data.php
Last active March 26, 2016 15:03
Magento 2 - Custom Logger
<?php
namespace MagePsycho\Demo\Helper;
/**
* @category MagePsycho
* @package MagePsycho_Demo
* @author magepsycho@gmail.com
* @website http://www.magepsycho.com
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*/