Mysql

When you're upgrading to MySQL 5.6 you may notice strict mode is turned on by default. You can disable it, but now might be a good time to get your schemas strict, to ensure smooth upgrade paths in the future.

Back to basic, let's brush up on some `SQL` :) At my company we have employees creating customer accounts every day. Sometimes we make mistakes, for instance, we forget to check if the company already was a customer (maybe 10y ago they may have had a product). Duplicate accounts can cause all sorts of problems, so I wanted way to detect them with `SQL`. The problem was, the company names may have been entered with different punctuation, whitespace, etc. So I needed similar names to surface from the depths of our database, not just exact matches (that would have been too easy :)

If you want to set up Ruby on Rails on Ubuntu Lucid from scratch, there are quite some articles online to choose from. I found most of them involve compiling, only highlight 1 aspect, or are a bit outdated. On top of that, getting it right can be hard as there are a number of issues related to Ruby and Debian/Ubuntu. This is an attempt to put all the sweet info in 1 place.

Some time ago I was in the situation where I was looking at 200 MyISAM tables screaming to get converted to InnoDB for performance reasons. You probably know that MyISAM is better at full-text searches and such, but what I needed was this database stop locking entire tables when I was just doing row-level interactions. Here's how I did **in one go**.

If you want to do command-line MySQL administration like restoring databases or dumping statistics, you need the root account and its password. Or do you?