Bin-Blog logoBin-Blog

Learn about the latest in Web Development – as soon as I do.

Archive for the ‘MySQL’ Category

Error Connecting to MySQL using Ruby on Rails in Linux – and its Solution

By • Apr 3rd, 2009

I am currently working on a new Rails project. Its been a while since I worked with rails – so I updated Rails using the command ‘sudo gem update --system‘. I started the inbuilt server and tried to open a page – and to my surprise, I found that Rails is having trouble connecting to the MySQL server. It was apparent that the mysql gem was missing. So I tried to install it using the command ‘sudo gem install mysql‘. That failed too – this is the error I got…



Mastering phpMyAdmin: A Review

By • Nov 26th, 2008

Some time ago, I was approched by the publisher of the book to write a review of their book ‘Mastering phpMyAdmin 2.11 for Effective MySQL Management by Marc Delisle[Affliate link]’. This got a bit delayed because of the plugin week. But I managed to finish the book today – so here is the review. Bottom line – most people are using phpMyAdmin for only the most basic operations(editing data, import, export, etc.). If you are one of them, you don’t need the book – you already know all you need to know about phpMyAdmin. But other(like me) use it for advanced purposes – to manage MySQL, create database/tables, run queries, etc. I would recommend you get this book. It covers everything from basic usage(which is a bit boring and should be skipped over) to advanced stuff(like designer view, configuration options, triggers, innoDB relation options etc.)



Remote Database Backup WordPress Plugin

By • Oct 13th, 2008

My second WordPress Plugin – Remote Database Backup. Its is based on the WordPress Database Backup plugin. If you are a regular wordpress user, you might be better off using WordPress Database Backup plugin instead of my version. But if you, like me, have a local server on your system and has a copy of your site on the local server as well as the online server, you will find great use for my plugin.



Compile and Install a LAMP(Linux/Apache/MySQL/PHP) Server from Source

By • Sep 22nd, 2008

In the last post, I described the method to install a LAMP server using apt in debian. But in some occasions, we need the latest build of the software – then we have to install it from source.



Document Formats

By • Apr 3rd, 2008

In FLOSS circles, March 26 is celebrated as the Document Freedom Day. Document Freedom Day (DFD) is a global day for document liberation. It will be a day of grassroots effort to educate the public about the importance of Free Document Formats and Open Standards in general. This is when I realized that people actually […]



Hello Script for PHP

By • Mar 15th, 2008

In the last post I introduced the concept of ‘Hello Script’ – a file that contains the most commonly used elements of a programming language so that it can be used as a cheat sheet when working with that language. I thought I can elaborate on that concept by creating Hello Scripts for all the […]