20071211 UTF-8 checklist

Following the discussion in the previous post (Reasons for using UTF-8) I thought it could be interesting to gather a series of steps needed to get a UTF-8 friendly environment. I’m going to focus on php and mysql, because using mysql and ruby/rails and utf8 tends to be kind of easier (specially since newer Rails [...]

20060806 Wrong location of mysql.sock?

I was trying to run bake script (for cakephp!) and it started complaining about not finding /var/mysql/mysql.sock – but why this path? I already had problems with mysql socket and ruby on rails. In that time, I was using xampp for apache, php and mysql, so the mysql socket was inside xampp folder and I [...]

20060420 /tmp/mysql.sock issue with Ruby On Rails under mac os X

I was retaking my self taught course of RoR yesterday and I started getting this error when accessing the database, each time I wanted to generate the scaffolding of one model: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ Oh well, I thought, aggghh. When I tried to install php, ror, mysql, etc… I [...]

20050922 Cool technique for restoring database dumps (with foreign keys)

You probably know there’s a quick way of dumping your whole database to a file, with mysqldump. This generates a .sql file containing all the data you would need to restore your database when moving to another server, or when doing a backup. Anyway, if you have ever tried to restore a database which contained [...]

20050617 Foreign keys and mysql

It seems like some people is not aware yet of the fact that with mysql you can have not only transactions but also foreign key constrains, apart from other features which were usually found only on expensive products like Oracle, MSSQL server, etc… The problem is that as these features weren’t available until some months/years [...]