Install mysql2 gem on Windows 7
Last couple of days ago, I was stuck to install mysql2 gem on windows7 for rails3 and tried lots of instructions by googling. Unfortunately, those were not worked for me.Finally, I have specified a ol...
Blog
Technical tutorials, system architecture insights, performance tuning guides, and real-world debugging logs from over 22+ years building production web systems.
Category:
•
MySql
Remote mysql backups on windows
In our day to day job needs to backup remote mysql database and sometimes may needs to synchronize with another one.It can be done by using following code snippet, no matter the remote server is windo...
•
MySql
Mysql backup on linux using ssh and cron
Sometimes, we may need to backup and synchronize mysql on linux as a background process. Linux has a great program for this called cron. It allows tasks to be automatically run in the background at re...
The bundled mysql.rb driver has been removed from Rails 2.2
After two months, I have started working on rails again and upgraded Rails to 2.3.2 on my laptop. After upgraded when I have tried to run a sample rails application and got following errors:=> Boo...
Read Full Article →
1 comment
•
PHP
Out of range value adjusted for column error
This is a known bug of MySql5 which I got while customizing one of my PHP projects. In the older version of MySql offered lots of freedom to developers. Previously anything can insert/modify into its...