MySQL 4.0.18

[l0rdphi1]

As of 12 Feb 2004, MySQL is up to 4.0.18. I've upgraded without any problems.wget http://www.l0rdphi1.com/tools/update.mysql.sh
sh update.mysql.sh(remember to enter 4.0.18 when it asks for a version)

[wdv]

Please note that this is a RedHat only script

[l0rdphi1]

Yeah, sorry :)

[jmstacey]

Yeah, I noticed that after I saw it was downloading rpm files:eek:

[jlasman]

Originally posted by l0rdphi1
wget http://www.l0rdphi1.com/tools/update.mysql.sh
sh update.mysql.sh(remember to enter 4.0.18 when it asks for a version)
Phil, will this work with DA or RHL 7.3 ?

Thanks.

Jeff

[ProWebUK]

Originally posted by jlasman
Phil, will this work with DA or RHL 7.3 ?

Thanks.

Jeff

They are standard MySQL RPMs, yes :).

Chris

[sander815]

could it be that this update caused the double mysql and mysqld entry in /etc/init.d mentioned in http://www.directadmin.com/forum/showthread.php?s=&threadid=2703 ?

as we don't know how it got there

[ProWebUK]

Its possible, infact it may be likely.... It was "mysql" (not mysqld)on the standard rpms I used yesterday...

Chris

[sander815]

hmmm, maybe something to take notice of?

on the other hand, i have not read more problems regarding mysql going down a lot

[sander815]

mwa, not likely that caused it, because before the update to 4.0.18 it aslo went down once or twice a week

[jmstacey]

Any nice little script for freebsd :p
Or any tips? Is it safe just to add it through the package system? (ie. it will remove the older version properly and install the new one wihout any lost data or settings?)

[DirectAdmin Support]

Hello,

I'll add that the DA installer is the culpret for mysql vs mysqld. It renamed mysql to mysqld so that the program checker has a standard name to deal with. The binary that runs is mysqld, so for consistency, mysql was renamed to mysqld. Might be something to take note of.

John

[jeffery]

Updated Successfully, Thanks!

[jeffery]

I have upgrade sucessfully on my Server A, but make a "pid not found" error on my Server B and thus unable to start the mysqld service.



any suggestion..? :confused:

[Peter Verrill]

Just noticed 4.0.20 :)

[ProWebUK]

Originally posted by Peter Verrill
Just noticed 4.0.20 :)

You can input the version when you run the script, so this will work fine :)

Chris

[jmstacey]

I modified the tool to work with FreeBSD
It has only been tested with FreeBSD 4.9
It should leave your data files intact but make backups prior to updating as always!


fetch http://www.jmstacey.net/da_tools/update.mysql.sh
chmod 755 update.mysql.sh
./update.mysql.sh


:)

[lesmak]

# ./update.mysql.sh


Upgrade to what version? (e.g. 4.0.18 )
4.0.18


Upgrading to MySQL 4.0.18

Receiving mysql-standard-4.0.18-unknown-freebsd4. (9908908 bytes): 100% (ETA 00:00)
9908908 bytes transferred in 116.4 seconds (83.11 kBps)
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]


Successfully upgraded to MySQL 4.0.18



Then I logged into DA, restarted Mysql and still it shows me old version.
jmstacey, is there something that I missed ?

[jmstacey]

What version of FreeBSD are you running?

There weren't any other erros displayed in what you posted. Does it report the wrong version in phpmyadmin as well?

I only tested it with 4.0.20 but it should work for any version, may want to try different version.

[ActiveDomain.NL]

Same thing here, after the update to 4.0.20:

da1# mysql -V
mysql Ver 12.21 Distrib 4.0.14, for unknown-freebsd4.7 (i386)

and

da1# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.14-standard

But I think I found the problem:
lrwxr-xr-x 1 root wheel 45 Apr 21 17:40 mysql -> mysql-standard-4.0.14-unknown-freebsd4.7-i386

After fixing this symlink, it seems to work a lot better:

da1# mysql -V
mysql Ver 12.22 Distrib 4.0.20, for unknown-freebsd4.7 (i386)

[jmstacey]

Ok, redownload the file and give it a go again. I added a line to remove all files with a mysql prefix to get rid of all the links and the old version of mysql. I didn't add it originally because my servers didn't have a problem recreating existing links to new locations. So hopefully this will fix it.
I tested it and installed 4.0.14, 4.0.18, and 4.0.20 and they all came on line and were working properly with the correct version numbers everywhere.

[ActiveDomain.NL]

jmstacey: tested on another server with 4.0.20, works fine now. Thanks :)

[lesmak]

Great job! Without problems.

Will this script work with any other version of mysql? That is, can I use this script in the future when newer version of mysql will come up?


jmstacey, do you have script like that that would upgrade exim ? :)


THX

[jmstacey]

It should work with future versions as long as the download directory doesn't change on the MySQL website.

I don't have one for exim at this point in time since there hasn't been a need to upgrade it.

[ActiveDomain.NL]

As far as I know there are some important bug fixed in the newest Exim version. As you can also read on the exim website:

The current version of Exim is 4.34. See the Download page to get a copy. There were a number of issues with earlier 4.3x versions so their use is discouraged. Security fixes in this release mean that all previous versions should be obsoleted in favour of 4.34.

I'm not sure how important they are, but Gentoo released a patch pretty fast, so I think it might be smart to do an upgrade.

[LyricTung]

FreeBSD script worked without a hitch on 4.10

[trza2k]

Installed and it worked fine. However when i did a reboot i noticed mysql was down but running in the ps's. :(

I saw suggestions in this thread and other about dual entries of mysql.

Did a "chkconfig --list" and found mysql and mysqld also found dual listings in dir /etc/init.d/

So did a "rm /etc/init.d/mysql" and a "chkconfig --del mysql" restarted the box and it worked fine after that.

Thought i would just share the commands incase anyone got stuck in the future :)

[Gala]

Originally posted by jmstacey
I modified the tool to work with FreeBSD
It has only been tested with FreeBSD 4.9
It should leave your data files intact but make backups prior to updating as always!


fetch http://www.jmstacey.net/da_tools/update.mysql.sh
chmod 755 update.mysql.sh
./update.mysql.sh


:)

worked fine with FreeBSD 4.10 ..Thanks;)

[vincenzobar]

i know this is old but i just had to say...




THANKS worked great...your a bad ass!!!!!!

[jmstacey]

Just an update. I moved the tool to another location.

[code]
fetch http://www.saevian.com/da_tools/update.mysql.sh
chmod 755 update.mysql.sh
./update.mysql.sh

[Marwen]

sorry for this question,

work your script for fedora core 2 ?

[jmstacey]

I do not know how DA manages MySQL on Fedora as I have only used FreeBSD.

But off the bat it will probably not work as the binary is optimized for FreeBSD and who knows about the file structure, but it may be easy enough to modify it if I knew more about the file structure and how DA manages MySQL. :)

[interfasys]

Some tech people tell me that it's not as easy to upgrade mysql on FreeBSD 5.x. there are no official 4.0.20 packages and da uses non-standard file locations.

It was painful...

[Chrysalis]

for freebsd 5.x I realised the same so I just installed the port version of 4.0.20 and told it to use the same db dir which works fine.

[jeffery]

Since MySQL is upgraded to 4.0.21, I used this tool to upgrade to the lastest version.

One thing to remind.

The script generates new S90mysql inside /etc/rc3.d/ and DA is using the script S90mysqld.

Just remove S90mysql to prevent from crashing upon reboot.


* for /etc/rc{2-6}.d also.

[cyril]

I just used this script to upgrade to MySQL 4.1.7, the new 'stable' version. Seems to work perfectly, I just had to change the URL to the RPM's a little.