Apple,howto,Lion,MySQL,OSX,PHP

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..

, , , , , , , , , ,

howto,MySQL,tips

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,tips

MySQL: Increment an existing record in the table

6 Apr , 2011  

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

, ,

events,MySQL,presentation

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.

, , , ,

MySQL,tutorials

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 […]

, , , ,

howto,MySQL,tips

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.

, , , , ,

howto,MySQL,Ubuntu

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

, , , , , ,

MySQL

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.

, ,

howto,MySQL,tips

Transfer database from one host to other using mysqldump and shell

3 Feb , 2010  

How to transfer mysql database using mysql command line.

, , , ,

MySQL

Difference between truncate and delete in mysql

31 Aug , 2009  

Difference between Truncate and delete command in MySQL

, ,