Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: haj on March 24, 2004, 01:31:16 AM
-
URL: http://no.longer.valid/phpwiki/index.php/How%20to%20Upgrade%20MySQL%20to%204.0.x%20for%20SME%20Server
Request: Please install, test and report your results.
-
I've been running MySQL 4 since 4.0.13 with the settings you describe and NO PROBLEMs what so ever so far. ;-)
-
rpm -e --nodeps mysql mysql-client mysql-server
gave
error: package mysql-client is not installed
I did install the fallowing and I think no problems.
MySQL-bench-4.0.18-0.i386.rpm MySQL-server-4.0.18-0.i386.rpm
MySQL-client-4.0.18-0.i386.rpm MySQL-shared-4.0.18-0.i386.rpm
MySQL-devel-4.0.18-0.i386.rpm MySQL-shared-compat-4.0.18-0.i386.rpm
Everything seems OK.
-
Followed the HOW-To exactly as described on a fresh 6.0 install as well as a 6.0.1 installation. The client version detected after the upgraded is still listed as 3.28. On my 6.0.1 installation, the upgraded MySQL 4.0.18 no longer starts itself after a reboot, and must be started manually.
-
Followed the HOW-To exactly as described on a fresh 6.0 install as well as a 6.0.1 installation. The client version detected after the upgraded is still listed as 3.28.
When you installed the rpms, didn't you have any error message ?
It should....
On my 6.0.1 installation, the upgraded MySQL 4.0.18 no longer starts itself after a reboot, and must be started manually.
Verify that:
- you have the two files /etc/rc.d/rc7.d/S90mysqld and /etc/rc.d/init.d/mysqld
- /etc/rc.d/rc7.d/S90mysqld is a symbolic link to /etc/rc.d/init.d/mysqld
-
haj,
Thank you for your response. Below is the error that I receive prior to installing the RPM files.
rpm -e --nodeps mysql mysql-client mysql-server
error: package mysql-client is not installed .
Afterwards, when I install the client program, everything seems to go fine, but when I check the version that is installed on my machine, it still comes back as "Client API version 3.23.56"
-
haj,
Thank you for your response. Below is the error that I receive prior to installing the RPM files.
rpm -e --nodeps mysql mysql-client mysql-server
error: package mysql-client is not installed .
Afterwards, when I install the client program, everything seems to go fine, but when I check the version that is installed on my machine, it still comes back as "Client API version 3.23.56"
What do you have when you type:
#rpm -qa | grep -i mysql
and wich version do you have when you type:
# mysql
-
haj,
#rpm -qa | grep -i mysql
MySQL-shared-compat-4.0.18-0
MySQL-client-4.0.18-0
perl-DBD-MySQL-1.2219-6
php-mysql-4.1.2-7.3.6es1
e-smith-mysql-1.10.0-02
MySQL-shared-4.0.18-0
MySQL-server-4.0.18-0
MySQL-devel-4.0.18-0
#mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.18-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Thanks again!
-
I've discovered that there is on more thing to be done once upgraded to MySQL 4.0.X. It is covered in this link.
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
After upgrading, update the grant tables to add new privileges and features. The procedure uses the script mysql_fix_privilege_tables and is described in section
--
Doug M.
"Rigger"
-
Rigger,
If you go to phpmyadmin and click on "Show PHP Information" what do you see under "mysql Client API Version" ?
Mine shows..
Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclien
-
I've discovered that there is on more thing to be done once upgraded to MySQL 4.0.X. It is covered in this link.
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
After upgrading, update the grant tables to add new privileges and features. The procedure uses the script mysql_fix_privilege_tables and is described in section
You are right I did this also but forgot to put it in the how to
HowTo updated
f you go to phpmyadmin and click on "Show PHP Information" what do you see under "mysql Client API Version" ?
Mine shows..
Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclien
The tip below should do it :)
-
Fine !
I did this upgrade yesterday (because of other issues described in a cry for help elsewhere), and ran the mysql_fix_script as advised on dev.mysql.com.
Luckily I have a dbtools manager installed, and that helped with my specific problem creating a grant (Thx, Dan, for your pointers in the 'Change Mysql password-howto').
Alls well that ends well!
But my yum hasn't figured out the update. This morning it presented me with a possibility to upgrade mysql to version 3.23.56-1.73
Apparently yum checks only version difference, not whether the installed version number is actually higher than the proposed.
How about it, Darrell ? (Not that I don't love your work! It has helped me out more times than I can count!).
-
Fine !
But my yum hasn't figured out the update. This morning it presented me with a possibility to upgrade mysql to version 3.23.56-1.73
Apparently yum checks only version difference, not whether the installed version number is actually higher than the proposed.
Noticed that.
Yum check for greatest version number but it seems that mysql 4 rpm spec differ from 3.x versions rpms....
All we need is a rpm guru to package mysql 4 rpms for SME :)
-
Noticed that.
Yum check for greatest version number but it seems that mysql 4 rpm spec differ from 3.x versions rpms....
Aaah, I see. Thanks, Laurent, and: Oops, sorry Darrell.
All we need is a rpm guru to package mysql 4 rpms for SME :)
I agree sincerely. Perhaps this is a job for Dan Brown ? It should be right up his alley.
-
FYI,
This how-to works fine with MySQL 4.1.11-standard on e-smith 5.6 as well.