Apache/PHP and MySQL are usually know as LAMP (Linux, Apache, MySQL, PHP). But on this page we will cover the SAMP (Snow Leopard, Apache, MySQL, PHP). In this tutorial you will learn how we can configure Apache/PHP/MySQL on Snow Leopard.

Apache and PHP by default installed in Snow Leopard so we don’t need to install these tools again. We only need to install MySQL. Now let’s install MySQL

(Keep reading…)

The database become more fragmented whenever you delete any large data from your sql database. It is always a very good practice to optimize your database time by time especially if you are dealing with a lot of varying characters (VARCHAR).

Optimizing a single table is very easy. Here is the command that how we can optimize MySQL database single table with command line.

(Keep reading…)