mysql

I am using an Amazon Linux AIM so the steps below assume this is the kind of image you have. Most of the steps below actually should work on any Linux server.
It is interesting to use an EBS filesystem so your data is persisted even after termination of your server instance. Using the instance filesystem to store data from MySQL should not be interesting for a database server, as all your data would be lost in case of termination of your instance.

While trying to install the MySQL gem in a Mac OS Lion, you might get an error message:

$ sudo gem install mysql -v '2.8.1'
Building native extensions. This could take a while...
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.
....
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.


Just formatted my machine and had to reinstall all my development environment in Windows 7. I ran into a problem that I never had before. After successfully installing MySQL 5.1, Ruby 1.8.6 and Rails 2.2.2 (I need those in these exact versions, because this is what my hosting service supports) I tried to migrate my database and the problems began.
After running "rake db:migrate" I got this error message:

!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!

To migrate your database in production environment simply run the following command.

rake db:migrate RAILS_ENV=production

After upgrading from Rails 2.0.2 to 2.3.5 my WEBrick server in NetBeans started printing the following message on its log and the application would not connect to the database.

The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.


I installed the refered gem but would still have the same problem when starting WEBrick, even after restart of the IDE.