UpGrate MySQL

[faison]

Hi there
I Upgrated mySQL

4.0 to 5.0

i used a option in tweak setting

chose MySQL 5.0
run Software/Update Server Software

buildapache

then

/scripts/perlinstaller --force Bundle::DBD::mysql


BUT

I got this Error


/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").



How can i do?

 

[mickalo]

Hi there
I Upgrated mySQL

4.0 to 5.0

i used a option in tweak setting

chose MySQL 5.0
run Software/Update Server Software

buildapache

then

/scripts/perlinstaller --force Bundle::DBD::mysql


BUT

I got this Error


/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").



How can i do?

if memory servers me, the problem has to do with the configuration file in the /etc folder: my.cnf
look at that file and coment out the following:

[mysql.server]
# basedir = /var/lib

comment out the basedir and restart MySQL. after the upgrade from 4 to 5, it reads from the old ver., 4 my.cnf.
If you do a search on this site on problems upgrading to MySQL 5, you should find a considerable amount of info on this topic

Mickalo