31.08.11

Tell Friends

Update PHP 5.2 and MySQL 5.0 to PHP 5.3.8 and MySQL 5.5.15 on CentOS 5.5

To upgrade PHP and mysql on CentOS we cannot rely on the ‘yum update’ command as CentOS default repositories don’t provide versions above PHP 5.2 and MySQL 5.0.77. So we will have to rely on alternative repositories. For this purpose Read the entire post…

25.08.11

Tell Friends

MySql Mass Convertion of Database Table’s Storage Engines from Other Types to InnoDB

A Few months back I had to convert moodle LMS database storage engine from MyISAM to InnoDB. Moodle has some 200+ databases and to manually convert each table takes an awful lot of time. My friend who was responsible for Read the entire post…

04.08.11

Tell Friends

Joining Three or More Tables in SQL With MySql (Nested Joins)

Joining three or more database tables seems a bit tricky. But once you know how to join three tables you can literally join any number of database tables. For the purpose of this tutorial I have four tables named Table1 Read the entire post…

12.07.11

Tell Friends

Simple Multiple Word Search Engine Concept With PHP & MYSQL

Searching the database for a single word is easy. How about if you want to have a multiple word search? With ordinary search it will only show the result if there is an exact match for the word sequence. What Read the entire post…