Skip to content

Instantly share code, notes, and snippets.

View kubaceg's full-sized avatar

Jakub Cegiełka kubaceg

View GitHub Profile
@kubaceg
kubaceg / color.sh
Last active August 29, 2015 13:55
Colorize bash prompt
export PS1="\[$(tput bold)\]\[$(tput setaf 2)\][\u@\h\[$(tput setaf 1)\] \w\[$(tput setaf 2)\]]\\$ \[$(tput sgr0)\]"
@kubaceg
kubaceg / install-1.0.0.php
Created February 7, 2014 12:04
Magento install select attribtue with multi shore values
<?php
$installer = $this;
$installer->startSetup();
$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$attribute = array(
'group' => 'General',
'type' => 'varchar',
@kubaceg
kubaceg / compress.sh
Created February 11, 2014 19:48
Compress all jpg files to 50% quality
for f in $(find . -name "*.jpg"); do convert -quality 50 $f $f; echo $f; done
@kubaceg
kubaceg / .bashrc
Created April 11, 2014 21:47
Restore last/only screen session
screen -r | screen -ls | sed 's/\..*//' | sed -n '/^\s[0-9]./p'
@kubaceg
kubaceg / dropAllTables.sh
Last active August 29, 2015 14:00
Drop all tables from mysql database
#!/bin/bash
#Default settings
username="root"
dbname="db"
host="localhost"
while getopts ":u:d:h:" opt; do
case "$opt" in
u) username=$OPTARG;;
d) dbname=$OPTARG;;
@kubaceg
kubaceg / convertEncoding.sh
Created May 5, 2014 13:31
Convert all tables to utf8
mysql --user=username --password=your_pass --database=dbname -B -N -e "SHOW TABLES" | awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' | mysql --user=username --password=your_pass --database=dbname &
@kubaceg
kubaceg / databaseBackup.sh
Last active May 1, 2017 11:32
n98Magerun magento database backup script, creates daily, weekly and monthly dumps
#!/bin/bash
#CONFIG
backupDir='/mnt/backup'
magentoDir='/var/www/magento/htdocs'
magerunPath='/usr/bin/n98-magerun.phar'
#NUMBER OF DAYS TO KEEP BACKUPS
dailyKeepDays=7
weeklyKeepDays=30
@kubaceg
kubaceg / mediaBackup.sh
Created June 16, 2014 09:55
magento media backup using rsync
#!/bin/bash
mediaPath="/var/www/magento/htdocs/media"
backupPath="/mnt/backup/media"
rsync -avr "$mediaPath/catalog" "$mediaPath/wysiwyg" "$mediaPath/categoriesDescription" --exclude="catalog/product/cache" --exclude=".thumbs" $backupPath
@kubaceg
kubaceg / toggleTouchpad.sh
Created August 26, 2014 13:30
disable/enable touchpad script
#!/bin/bash
synclient TouchpadOff=$(synclient -l | grep -c 'TouchpadOff.*=.*0')
@kubaceg
kubaceg / dstat
Created November 13, 2014 18:19
Dstat usage
#Vizualize dstat data http://vmstax.michenux.net/
dstat -c -n -N eth0,lo -m -s -d --output dstat2.csv