MySQL on Mac OS X

MySQL on Mac OS X 10.7.3 Installation & configuration Download the mac based tar or dmg from MySQL website Add group mysql Add user mysql who’s group is mysql shell> cd /usr/local shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz shell> cd mysql shell> chown -R mysql . shell> chgrp -R mysql . shell> scripts/mysql_install_db –user=mysql shell> chown -R […]

Read More MySQL on Mac OS X

Start using PostgreSQL now….

Spend 10 minutes and have PostgreSQL on your own lilo flavor Purpose of this article to give jump starts to install and performed basic PostgreSQL (pgsql) administrator / user job. Download binaries from this location tar -xzvf postgresql-8.3.1.tar.gz ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su – postgres /usr/local/pgsql/bin/initdb […]

Read More Start using PostgreSQL now….

Sybase iSQL ASE 12.5 drive

This article will get you up and running with Sybase database commands. I personally refer it many times when I need  specific command. I kept it comprehensive reference material for anyone to jump start. What is difference between SQL & T-SQL? SQL- set of sqls are submitted individually to the database server. T-SQL- the batch […]

Read More Sybase iSQL ASE 12.5 drive

MYSQL replication in the same box

MYSQL replication in the same box   MYSQL 5.0.17 standard (SLAVE) – MYSQL 4.1.1 standard (MASTER) – MASTER running on port 3306 SLAVE running on port 3308 MASTER (my.cnf) server-id = 1 log-bin SLAVE (my.cnf) [mysqld] server-id = 2 master-host = localhost master-user = root master-password = mysql master-port = 3306 replicate-do-db = […]

Read More MYSQL replication in the same box