Wednesday, March 24, 2010

Mysql Unknown Variable character-set-server

If you've recently upgraded to MySQL 5.1.45, you might experience a problem running mysql client. The error message says:

/usr/bin/mysql: unknown variable 'character-set-server=utf8'

The reason is that mysql client no longer supports character-set-server parameter. Actually I don't know why, the official ChangeLog doesn't
include any explanations. The solution is to disable character-set-server option
inside /etc/mysql/my.cnf

[mysql]
character-sets-dir=/usr/share/mysql/charsets
#character-set-server=utf8

Wednesday, January 27, 2010

Vim Terminal Commands

There is a possibility to run terminal commands inside Vim. Just type:

:! command [Hit Enter]

Also you can invoke a shell inside Vim:

:! bash [Hit Enter]

Also Vim has third party addons (vim-shell) that allow to use shell in more natural manner. But I would not recommend you to use Vim this way. There is much better way to achieve the same things - just use screen. It allows you to split your terminal vertically by pressing Ctrl-A S. Then you can use Ctrl-A Tab or Ctrl-A Ctrl-I to switch between them.