mysql.sock path in Mac OS X

31 Aug , 2011  

The default path on which the MySQL starts is service is different from the one defined in PHP. There are two ways to correct it, read more..

, , , , , , , , , ,


How to reset lost MySQL password

8 Jun , 2011  

how you can rest a lost MySQL password. Using this procedure you can reset the lost password of root or any other MySQL user. The best part is, it only resets the password, keeping your tables and data inside them quite safe.

, , , ,


MySQL: Increment an existing record in the table

6 Apr , 2011  

MySQL: Increment or Decrement an existing record in the table.

, ,


MySQL Optimization from a developer’s point of view

17 Mar , 2011  

Undoubtedly a Web Application’s backbone is a database. Apparently, the Web Application’s performance is dependent on the database’s overall performance. However, some developers blame Database Administrators for non-performing of the web application to the end user.

, , , ,


Difference between InnoDB and MyISAM in MySQL

15 Nov , 2010  

MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The major differences between these two storage engines are : InnoDB supports transactions which is not supported by tables which use MyISAM storage engine. InnoDB has […]

, , , ,


Enable query cache in MySQL to improve performance

11 Nov , 2010  

Learn how to enable query cache in MySQL and how it helps to improve performance.

, , , , ,


Install MySQL Server 5 on Ubuntu and adding support to PHP

8 Oct , 2010  

Install MySQL Server 5 on Ubuntu and adding support to PHP

, , , , , ,


Memory(heap) Storage engine in MySQL

4 Aug , 2010  

What is Memory(heap) Storage engine in MySQL ? Why should we use it and what are the pros/cons of using Memory Storage engine.

, ,


Transfer database from one host to other using mysqldump and shell

3 Feb , 2010  

How to transfer mysql database using mysql command line.

, , , ,


Difference between truncate and delete in mysql

31 Aug , 2009  

Difference between Truncate and delete command in MySQL

, ,