Git reload remote branche list

Tip: When you delete branches using git branch -d <branchname> or git push origin :<branchname> the reference is only deleted locally. This means that for other team members the deleted branches are still visible when they do a git branch -a. To solve this your team members can prune the deleted branches with git remote prune <repository> , this is typically git remote prune origin.

Capistrano postgresql error when running cap deploy:update

....
Can't find the 'libpq-fe.h header
....

Fix:

yum install postgresql-devel # or apt-get install ....

Nginx startup scripts

Create nginx startup script in /etc/init.d/nginx

cd /opt
wget -O init-rpm.sh http://library.linode.com/assets/603-init-rpm.sh
mv /opt/init-rpm.sh /etc/rc.d/init.d/nginx
chmod +x /etc/rc.d/init.d/nginx
chkconfig --add nginx
chkconfig nginx on

via: linode

Mac os mysql localhost / 127.0.0.1 problem

Mac os fix localhost / 127.0.0.1 problem: Add to php.ini:

pdo_mysql.default_socket=/tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

restart apache server:

sudo apachectl restart

Postgres rails socket problem

Postgres problem in rails

could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

Resolve:

mkdir /var/pgsql_socket/ 
ln -s /private/tmp/.s.PGSQL.5432 /var/pgsql_socket/

via: http://jaygoldman.com/2012/11/fixing-postgres-connection-errors-on-mountain-lion/

Translation problem in mysql phpmyadmin

For new versions of mysql edit /etc/mysql/my.cnf

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

Restart mysql service here Check results using :

mysql> show variables like 'char%';
mysql> show variables like 'collation%';

Cyrilic \w+ problem

Just case. RegExp don't like cyrilic symbols and willn't be processed by '\w+' so use [\u0400-\u04FF] for this case.