Tuesday, February 1, 2011

Mysql Won't start (two instance on same server)

A Solution:

Install mysql db again at new location,use following command:
 
/usr/bin/mysqld_safe --defaults-file /etc/my.cnf

Restart Mysql:
     /etc/init.d/mysqld restart

/usr/local/bin/mysqld_safe --defaults-file /usr/local/etc/my.cnf
 
mysql_install_db --user=mysql --ldata=/new-data-location
mysqld_safe --datadir=/new-data-location --user=mysql &

/usr/local/mysql/share/mysql/mysql.server start