Image optimize

Run optipng to optimize png files in directory:
for i in `ls`; do optipng -i0 -o7 -zm1-9 $i; done

Run optipng for a single file:
/usr/bin/optipng -i0 -o7 -zm1-9 upload/banner/kaspi132px.png

Run jpegoptim for a single file:
/usr/bin/jpegoptim –strip-all upload/banner/kaspi132px.jpg

Run gifscle for a single file:
/usr/bin/gifsicle -b -O2 upload/banner/kaspi132px.gif

mysql export a single table

mysqldump -u -p db table1 table2 table3

Yii turn debug panel on/off

Edit config/main.php (or config/web.php), add or remove the following code:
$config[‘bootstrap’][] = ‘debug’;
$config[‘modules’][‘debug’] = ‘yii\debug\Module’;

Mysql check corrupted tables

mysqlcheck -c databasename -uyourusername -pyourpassword

git rename local branch

If you want to rename a branch while pointed to any branch, simply do :
git branch -m oldname newname

If you want to rename the current branch, you can simply do:

git branch -m newname

Parking domain with htaccess

This setup excludes base url http://www.example.com from rewritting but any other url for example http://www.example.com/dis will be rewritten to http://www.example.net/dis

RewriteEngine on
RewriteCond %{REQUEST_URI} !^/$
RewriteCond %{HTTP_HOST} ^example.com [NC,OR]
RewriteCond %{HTTP_HOST} ^www.example.com [NC]
RewriteRule ^(.*)$ http://example.net/$1 [L,R=301,NC]

Apache virtual hosting with aliases

For Debian/Ubuntu default installation no need to add NameVirtualHost directive.
working configuration:


ServerName yourdomain.com
ServerAlias www.yourdomain.com
ServerAdmin webmaster@localhost

DocumentRoot /var/www/path

ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/

AllowOverride None
Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from none

ErrorLog ${APACHE_LOG_DIR}/error-yourdomain.log

# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel error

CustomLog ${APACHE_LOG_DIR}/access-yourdomain.log combined

php image optimization utilities

php library: https://github.com/bensquire/php-image-optim
png: advpng, optipng, pngout, pngquant, pngcrush
jpg: jpegoptim, jpegtran
gif: gifscle

git soft remove last commit

git reset –soft HEAD~1

Beanstalk Job Cycle

Tubes:
[ready]->[reserved: in processing]->[delayed: (timeout before again moving to ready tube)]