Topic: MySQL 4.0.21-0.i386 Upgrade for SME 6.0 HowTo:

[SharedMedia]

(Revised HowTO: SOON TO BE UPDATED)
This HowTO: has been posted many times, with numerous suggestions and error reporting. I have revised this HowTO: and WILL enable you to upgrade MySQL 3.23 to MySQL 4.0.20 (or later Versions) FLAWLESSLY on SME 6.0 Unsupported Release and show NEW version in any version of phpMyAdmin.

(Example)
Welcome to phpMyAdmin 2.6.0-alpha2
MySQL 4.0.20-standard running on localhost.....

1) DOWNLOAD MySQL 4.0.20-0.i386.rpm(s) or latest "Stable" Versions
Download MySQL 4.0 rpms from mysql.com (Linux x86 RPM downloads section) to
/home/e-smith/files/users/admin/home/MySQL-Upgrade-SME.6.0 directory. ( I created "MySQL-Upgrade-SME.6.0" to use)

Download the following:
MySQL-shared-compat-4.0.20-0.i386.rpm
 (Dynamic client libraries
(including 3.23.x libraries)  4.0.20-0 479.7K link)
MySQL-server-4.0.x-0.i386.rpm
(Server  4.0.20-0 9.8M link)
MySQL-client-4.0.x-0.i386.rpm
(Client programs  4.0.20-0 2.6M link)
MySQL-devel-4.0.x-0.i386.rpm
 (Libraries and header files  4.0.20-0 925.7K link)

  Note: replace 4.0.x with current MySql STABLE version availaible (was 4.0.20 at time of writing)

2) STOP MYSQL
service mysqld stop

3) REMOVE OLD RPMS
rpm -e --nodeps mysql mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

4) INSTALL NEW RPMS
Cd to the directory where you downloaded the rpms:
rpm -Uvh MySQL-*.rpm

5) CONFIGURE
chkconfig --levels 2345 mysql on
mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (to enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
ln -s /usr/sbin/mysqld /usr/libexec/ (for conf-mysql-password script)
service mysqld restart

Then to make sure that your grant tables are current when you update to the new version:
/usr/bin/mysql_fix_privilege_tables

Upgrade Complete ( No Errors )

[cydonia]

Has anyone tried the above and if so, how did it go?

I am going to need to upgrade since the current exported data causes problems with my virtual hosts server (running 4.0.x).

Also, do you lose your data in upgrading?*

Should you backup before the upgrade?

THanks.

[Normando]

work fine!!!!!!!!!!! No backups are necesary, no lose data!!!
Thanks SharedMedia

[cydonia]

Thanks for that.

Will give it a shot and let you know who it goes.

Cheers.
Tristan

[edb]

Thanks alot for the HowTo SharedMedia your instructions worked absolutely perfect.
I like no brainers ... do you have a HowTo on upgrading PHP to version 4.3

[cydonia]

Upgrade couldn't have gone smoother!  

Thanks for the HowTo.  It worked perfectly.


Thanks again.
Tristan

[SharedMedia]

Safe to Delete Posting.

[mbachmann]

Did you join the devinfo mailing list, SharedMedia?

[wyron]

Upgrade couldn't have gone smoother!  
Thanks for the HowTo.  It worked perfectly.
Thanks again.
Tristan

I really wish I could express the same sentiment.
I can't, though.
The upgade went smoothly (Howto followed to the letter), but in my case the result was 'package mysql is not installed' when I rpm -q mysql.
Whatever happened ??

[cydonia]

I really wish I could express the same sentiment.
I can't, though.
The upgade went smoothly (Howto followed to the letter), but in my case the result was 'package mysql is not installed' when I rpm -q mysql.
Whatever happened ??

Very strange indeed.  Apart from leaving two steps in the config stage out, i also followed it exactly.

I am running plain old 6.0.1, newly installed.

[wyron]

=cydonia
I am running plain old 6.0.1, newly installed.

Yeah - me too.
And I even went through the command line history to make sure I hadn't wet myself somewhere along the line.
The strange thing is, that the rpm's are installed (I tried to -Uvh them again).
Well then, I guess I'll have Yum install 3.23.58 for me, when I've reinstalled the server. Thank Linus I hadn't put it into production yet.

[SharedMedia]

Safe to Delete Posting.

[SharedMedia]

Safe to Delete Posting.

[Normando]

Hi SharedMedia. Thanks for the script, run ok, but I have one issue: After update to 4.0.21 with your script I have the following error when I execute mysql_setpermission:
[root@servidor bin]# mysql_setpermission
password=/SV1aAwt3ouMzYvEA+lMoEp0mS6T3bhInAsI1pkvo6+mObj8n1qmdPfooW1xnb/E6rvVgtEAWM7S


#------------------------------------------------------------
# TEMPLATE END
#------------------------------------------------------------
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 at (eval 7) line 3
Compilation failed in require at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /usr/bin/mysql_setpermission line 70

[root@servidor bin]#

What happens? I use very much mysql_setpermission.
In your first howto about upgrade mysql, I have no trouble with mysql_setpermission. The first howto you write based in 4.0.20, and this script is based in 4.0.21 What you think
My webmail have error now and I don't login. PHPMyAdmin, have the same error:
1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

Well, my server run ok before I use this script.

Please, if you can help me because I tested in the production server, and now is crash!!!!

[Normando]

I have fix this.........ufffffffffffffff
Well, I downgrade from 4.21.0 to 4.20.0 and now run ok!!!! Please, to the comunity, test this script (for 4.21.0) in test server.
I don't know if it's important, but I have php 4.3.9
PicsOne