Category Archives: MySql
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 older version of mysql2 during installation which worked for me. Following are the steps which i did: Install Mysql 5.5…
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 windows or Linux. Save the following code snippet as a batch(.bat) file and setup a task scheduler. set DATET=%date:~-4%_%date:~7,2%”your…
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 regular intervals. Create a script file(.sh) using following code snippet to backup and restore database in to another database: ssh…
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: => Booting WEBrick=> Rails 2.3.2 application starting on http://0.0.0.0:3000!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install…
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 tables but it does not seem to be practical anymore. No need to worry about the error. You can fix…