Upgrading problems

[svar]

I tried to upgrade from 4.01 to 4.03(via rpm), but something went wrong linux:/home/me/TMPOUT #
rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
linux:/home/me/TMPOUT # rpm -i MySQL-4.0.3-0.i386.rpm
package MySQL-4.0.3-0 is already installed
linux:/home/me/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed

How can I clean up the old mysql distribution for good?

Thanks, svar

 

[sleipnir214]

Have you tried performing the install of the new rpm using the -U (for upgrade) flag? ______________________________________________________________________
TANSTAAFL!

 

[svar]

Yes, but still...
linux:/home/db/TMPOUT # rpm -q mysql
package mysql is not installed

linux:/home/db/TMPOUT # rpm -qa | grep MySQL
MySQL-shared-4.0.3-0
MySQL-client-4.0.3-0
MySQL-devel-4.0.3-0
MySQL-4.0.3-0
linux:/home/db/TMPOUT # /usr/bin/mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


Any ideas??

 

[danielhozac]

Is the MySQL server running? Try restarting it if it is. //Daniel

 

[svar]

You mean /usr/bin/mysql as before, where it complains about the socket
or /usr/bin/mysqld_safe
(in which case I get:

#ls /usr/bin/my*
-rwxr-xr-x 1 root root 874496 Aug 26 13:57 mysql
-rwxr-xr-x 1 root root 3448 Aug 26 13:58 mysql_config
-rwxr-xr-x 1 root root 2976 Mar 23 21:26 mysql_convert_table_format
-rwxr-xr-x 1 root root 10133 Aug 26 13:58 mysql_explain_log
-rwxr-xr-x 1 root root 2654 Aug 26 13:58 mysql_find_rows
-rwxr-xr-x 1 root root 15255 Mar 23 21:26 mysql_setpermission
-rwxr-xr-x 1 root root 111523 Aug 26 13:58 mysqlaccess
-rwxr-xr-x 1 root root 699300 Aug 26 13:57 mysqladmin
-rwxr-xr-x 1 root root 726380 Aug 26 13:57 mysqlbinlog
-rwxr-xr-x 1 root root 695316 Aug 26 13:57 mysqlcheck
-rwxr-xr-x 1 root root 9638 Aug 26 13:58 mysqld_safe
-rwxr-xr-x 1 root root 709916 Aug 26 13:57 mysqldump
-rwxr-xr-x 1 root root 692932 Aug 26 13:57 mysqlimport
-rwxr-xr-x 1 root root 13156 Mar 26 19:56 mysqlnavigator
-rwxr-xr-x 1 root root 693484 Aug 26 13:57 mysqlshow
linux:/usr/bin #


linux:/usr/bin # mysqld_safe
/usr/bin/mysqld_safe: my_print_defaults: command not found
The file /usr/sbin/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.

ls: /usr/sbin/mysqld: No such file or directory

What next?
Does this mean the rpm is bad and I need to get rid of it and install
from the tarball?

Thanks, svar

 

[danielhozac]

Try running /etc/init.d/mysql start instead. It should start the MySQL server. //Daniel

 

[svar]

No, there is no /etc/init.d/my*

Besides, I tried installing from the tarball and
it still does not work:
linux:/usr/local # groupadd mysql
groupadd: group mysql exists
linux:/usr/local # useradd -g mysql mysql
useradd: user mysql exists
linux:/usr/local # ln -s /usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686 mysql
linux:/usr/local # cd mysql
linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
Unknown suffix ' ' used for variable 'thread_concurrency' (value '4 # Try number of CPU's*2')
./bin/mysqld: Error while setting value '4 # Try number of CPU's*2' to 'thread_concurrency'
Installation of grant tables failed!

It tries to create ibdata1 etc to /usr/local/bin/data
instead of /var/log/mysql, although that is what
/etc/my.cnf specifies

How can I correct that?

Thanks, svar