Sys-Admin Information’s

Share Knowledge, Distribute Knowledge, Capture & Modify Knowledge, Create Knowledge

Archive for the ‘Mysql’ Category

Oracle Heterogeneous Configuration Service (ORACLE to MySQL)

with 2 comments

PART I : Setting up ODBC driver

1. Install mysql-connector-odbc-3.51.12-linux-i686.rpm

bash> rpm –ivh mysql-connector-odbc-3.51.12-linux-i686.rpm

2. Start Mysql Daemon

bash> /etc/init.d/mysqld start
Initializing MySQL database:                               [  OK  ]

3. Configure ODBC

bash> ODBCConfig

4. Modify : /etc/odbc.ini

bash> vi /etc/odbc.ini
[trans]
Driver                             = MySQL ODBC 3.51 Driver
DATABASE                    = kampus
DESCRIPTION             = punya_kampus
PWD                                = password
PORT                              = 3306
SERVER                         = localhost
UID                                 = root

Read the rest of this entry »

Written by Henri Simatupang

March 5th, 2008 at 1:55 pm

Posted in Mysql, ODBC, Oracle

Tagged with

ERROR! MySQL manager or server PID file could not be found!

with 2 comments

Don’t Panic if you get this error when you start, restart or stop your mysql engine.
I get error like this "/etc/init.d/mysql: /usr/local/bin/hostname: not found
/etc/init.d/mysql: /usr/local/bin/hostname: not found
ERROR! MySQL manager or server PID file could not be found!"
when i restart the mysql, yes..dont panic,
Read the rest of this entry »

Written by Hendrawan

September 18th, 2007 at 3:13 pm

Posted in Mysql