MySQL 4.0.21

[jmstacey]

MySQL 4.0.21 was released

l0rdphi1's MySQL update tool for Redhat

wget http://www.l0rdphi1.com/tools/update.mysql.sh
sh update.mysql.sh


My update tool for FreeBSD 4.x

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

[l0rdphi1]

I've updated without problem! :)

[PauGasol]

Thanks

[jjma]

The update script doesn't work for me:

Upgrade to what version? (e.g. 4.0.15 )
4.1.17


Upgrading to MySQL 4.1.17


--12:10:00-- http://mysql.he.net/Downloads/MySQL-4.0/MySQL-server-4.1.17-0.i386.rpm
=> `MySQL-server-4.1.17-0.i386.rpm'
Resolving mysql.he.net... 64.62.223.52
Connecting to mysql.he.net[64.62.223.52]:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://hail.he.net/cgi-bin/error404 [following]
--12:10:00-- http://hail.he.net/cgi-bin/error404
=> `error404.18'
Resolving hail.he.net... 64.62.223.2
Connecting to hail.he.net[64.62.223.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]

[ <=> ] 728 --.--K/s

12:10:01 (6.94 MB/s) - `error404.18' saved [728]

regards

Jon

[SeLLeRoNe]

Upgrading to MySQL 4.0.20


fetch: http://mysql.he.net/Downloads/MySQL-4.0/mysql-standard-4.0.20-unknown-freebsd4.7-i386.tar.gz: size of remote file is not known
Receiving mysql-standard-4.0.20-unknown-freebsd4.: 728 bytes
728 bytes transferred in 0.0 seconds (2.49 MBps)

gzip: stdin: not in gzip format
tar: Child returned status 1
tar: Error exit delayed from previous errors
ln: mysql-standard-4.0.20-unknown-freebsd4.7-i386/data: No such file or directory
chown: /usr/local/mysql/*: No such file or directory
Stopping mysqld: [ FAILED ]
cd: can't cd to /usr/local/mysql


Successfully upgraded to MySQL 4.0.20




i've this error and now i'm withou mysql, please help me quickly

thanks

[SeLLeRoNe]

i've modified the script and now i've installed MySQL 4.1.8 :)

now it doesent start...


Starting mysqld: [ OK ]
/usr/libexec/ld-elf.so.1: /lib/libcrypt.so.2: Undefined symbol "_CurrentRuneLocale"
/usr/libexec/ld-elf.so.1: [13:54:20] root@One.ALLCrazy.net [/usr/local/etc/rc.d]
/lib/libcrypt.so.2: Undefined symbol "_CurrentRuneLocale"
>


i've theese two errors, help me please

[SeLLeRoNe]

same error if i put 4.0.23 ver

[AleSSaNDRo]

also to me it has succeeded the same thing: (
I have dawned mysql with the commandos:
fetch http://www.saevian.com/da_tools/update.mysql.sh
chmod 755 update.mysql.sh
/update.mysql.sh
and i have restart mysql but it is down and not working :(

[jjma]

Is there any update on this? I would like to install the latest mysql version but the developers script doesn't appear to work.

regards

jon

[SeLLeRoNe]

me too, please help us :)

[jmstacey]

I have not tested this script with MySQL 2.1.x and doubt it will work if there have been critical changes to the way binaries are released. I'll play around with it when I get some free time (when I get my toy server setup again)

In the mean time I updated the script with a couple of modifications. Nothing major though. I have successfully upgraded from mysql 2.0.22 to 2.0.23 on FreeBSD 4.10

[California]

Thanks, Jon!

I upgraded effortlessly from mysql 4.0.17 to 4.0.23 on FreeBSD 4.9.

Three simple commands and 30 seconds did the trick!

[SeLLeRoNe]

the problem is only mine? i'm using freebsd 5.2.1 :(

[CrazyMouse]

I think that is the problem, the tool is written for FreeBSD 4.x

Are ther more, that upgrade with out any problem? I always wait a few day's that I know for sure, it works ;)

[jmstacey]

This script does not support the 5.x line of FreeBSD because MySQL AB has not begun releasing optimized binaries for it. It must be compiled from source. I have been playing with a script to download, configure and build but I'm afraid its not worth it since so many things can go wrong during a build it would be easier to run the commands one by one and fix any errors as they happen.

[jjma]

My issues were with the Redhat script. Anyone else with similar difficulties want to help out?

Thanks

Jon

[jjma]

Originally posted by jjma
Is there any update on this? I would like to install the latest mysql version but the developers script doesn't appear to work.


Just updated the mysql server tonight. Seems like the mirror site was failing.

One thing I noticed was two instances of the mysql start up script - the old one mysqld and the new mysqld. I deleted the old and renamed the new mysqld.

This was in /etc/rc.d/init.d/ & /etc/rc.d/rc0.d/

Thanks

Jon

[CrazyMouse]

Works fine for me on a freeBSD 4.9

[noname**]

MySQL guys recommend using ports to install MySQL. http://dev.mysql.com/doc/mysql/en/freebsd.html

The easiest (and preferred) way to install MySQL is to use the mysql-server and mysql-client ports available at http://www.freebsd.org/. Using these ports gives you the following benefits:
A working MySQL with all optimizations enabled that are known to work on your version of FreeBSD.

Automatic configuration and build.

Startup scripts installed in /usr/local/etc/rc.d.

The ability to use pkg_info -L to see which files are installed.

The ability to use pkg_delete to remove MySQL if you no longer want it on your machine.

[mattbates]

To install from ports, what customisations need to be made? I mean, I know that the MySQL data is stored in /home/mysql as opposed to the normal location(s).

Are there any special instructions anybody can advise?

Thanks in advance.

Matt

[jmstacey]

Installing using ports is MySQL's preferred way because it's the easiest. Since DA simply uses a premade binary (on most OS's) it's easier to just download a new binary and be done with it.

If you insist on installing with ports, you'll probably want to keep an eye out for the directory it try's to install it in. You might have to specify when doing the build that the data directory should be in /usr/local/mysql (which is a link to /home/mysql), for example.

[dan35]

Nevermind!

[Dennis]

Hi!

Perfect upgrade script! Upgraded to MySQL 4.0.23 with FC2....But had to modify the mirrors to a Dutch one.

Is there anyone working with MySQL 4.1.9?? Because that one is recommended by MySQL.com.

Dennis

[nuclear]

4.1.9 worked fine for me on FC2. Just had to edit the script and change the 3 wget commands to reflect the MySQL-4.1 directory instead of 4.0

[servertweak]

does anyone here has an updates
update.mysql.sh for 4.1.10 ?

[thoroughfare]

BTW if you install MySQL as a port on FreeBSD and it won't start, remember that the port's rc.d script uses the rc.subscr system so you'll need to add 'mysql_enable="YES"' to your /etc/rc.conf.

HTH,
Matt :)

[jjma]

Originally posted by nuclear
4.1.9 worked fine for me on FC2. Just had to edit the script and change the 3 wget commands to reflect the MySQL-4.1 directory instead of 4.0

Can you shhow how?

Ja

[Icheb]

Originally posted by jjma
Can you shhow how?

Ja
Easy:

This one works for 4.1:

#!/bin/sh

cd $HOME

echo -e "\n\n\033[1;37mUpgrade to what version? (e.g. 4.1.10a )\033[0m"
read INSTALL_VER

echo -e "\n\n\033[1;37mUpgrading to MySQL ${INSTALL_VER}\033[0m\n\n";

wget http://mysql.he.net/Downloads/MySQL-4.1/MySQL-server-${INSTALL_VER}-0.i386.rpm
wget http://mysql.he.net/Downloads/MySQL-4.1/MySQL-client-${INSTALL_VER}-0.i386.rpm
wget http://mysql.he.net/Downloads/MySQL-4.1/MySQL-devel-${INSTALL_VER}-0.i386.rpm

rpm -Uvh ./MySQL-server-${INSTALL_VER}-0.i386.rpm ./MySQL-client-${INSTALL_VER}-0.i386.rpm ./MySQL-devel-${INSTALL_VER}-0.i386.rpm

rm -fr ./MySQL-server-${INSTALL_VER}-0.i386.rpm ./MySQL-client-${INSTALL_VER}-0.i386.rpm ./MySQL-devel-${INSTALL_VER}-0.i386.rpm

service mysql restart

echo -e "\n\n\033[1;37mSuccessfully upgraded to MySQL ${INSTALL_VER}\033[0m\n\n";

exit 0;
4.1.10a was released today or something, at least, I got an mail about a few exploits in the sql daemon, so I noticed an update to the daemon today :)

[servertweak]

IS THAT GOOD FOR LINUX ENTERPRIZE 3?

[Icheb]

Originally posted by servertweak
IS THAT GOOD FOR LINUX ENTERPRIZE 3?
Caps aren't needed, it will only irritate people.

If you mean Red Hat Enterprise, it should work, I've tested this on rh 9.0 installations, works great :).

[Newbee]

Originally posted by jmstacey
[B]MySQL 4.0.21 was released

l0rdphi1's MySQL update tool for Redhat

wget http://www.l0rdphi1.com/tools/update.mysql.sh
sh update.mysql.sh




Can anyone get this to work?

I get up to the point where it asks which version, then when I type 4.0.23 it makes the conenction but the speed is soooooooo slow 840.39B/s even if I quit and try again - whats going on?

Any other ways to upgrade?
thanks.

[jw00dy]

Originally posted by jmstacey
MySQL 4.0.21 was released

l0rdphi1's MySQL update tool for Redhat

wget http://www.l0rdphi1.com/tools/update.mysql.sh
sh update.mysql.sh


that worked like a charm on CentOS 3.3. Updated to v 4.0.24.

thank you for posting it.

[torp]

Originally posted by jjma
One thing I noticed was two instances of the mysql start up script - the old one mysqld and the new mysqld. I deleted the old and renamed the new mysqld.

This was in /etc/rc.d/init.d/ & /etc/rc.d/rc0.d/


In init.d I have mysql and mysqld

In rc0.d I have K20mysqld

Should I remove any of these?

PS: Have had a lot of MySQl-server trouble lately - since I upgraded to 4.17. I'm now on 4.24. Maybe this could be the cause of it...?

[jmstacey]

You should only have mysqld in your init.d directory. I wouldn't worry about any of the rcX.d directories however (where X is a number)

[jmstacey]

Something I recently discovered when migrating to the new MySQL method in Debian (http://www.directadmin.com/features.php?id=477)

1. Make sure mysqld is the only MySQL script in /etc/init.d
2. Run "update-rc.d mysqld defaults"
That will properly add the the links to the rcX.d directories for MySQL

If there are other links of MySQL in those directories, you might need to run something like "update-rc.d mysql remove", or something near that.

[smiling_pig]

I get this error on CentOS 3.1


--10:52:27-- http://mysql.he.net/Downloads/MySQL-4.0/MySQL-server--0.i386.rpm
=> `MySQL-server--0.i386.rpm'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.62.223.52]:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://hail.he.net/cgi-bin/error404 [following]
--10:52:27-- http://hail.he.net/cgi-bin/error404
=> `error404.6'
Resolving hail.he.net... done.
Connecting to hail.he.net[64.62.223.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]

[ <=> ] 728 710.94K/s

10:52:27 (710.94 KB/s) - `error404.6' saved [728]

--10:52:27-- http://mysql.he.net/Downloads/MySQL-4.0/MySQL-client--0.i386.rpm
=> `MySQL-client--0.i386.rpm'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.62.223.52]:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://hail.he.net/cgi-bin/error404 [following]
--10:52:27-- http://hail.he.net/cgi-bin/error404
=> `error404.7'
Resolving hail.he.net... done.
Connecting to hail.he.net[64.62.223.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]

[ <=> ] 728 710.94K/s

10:52:27 (710.94 KB/s) - `error404.7' saved [728]

--10:52:27-- http://mysql.he.net/Downloads/MySQL-4.0/MySQL-devel--0.i386.rpm
=> `MySQL-devel--0.i386.rpm'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.62.223.52]:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://hail.he.net/cgi-bin/error404 [following]
--10:52:27-- http://hail.he.net/cgi-bin/error404
=> `error404.8'

Resolving hail.he.net... done.
Connecting to hail.he.net[64.62.223.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]

[ <=> ] 728 710.94K/s

10:52:28 (710.94 KB/s) - `error404.8' saved [728]

error: open of ./MySQL-server--0.i386.rpm failed: No such file or directory
error: open of ./MySQL-client--0.i386.rpm failed: No such file or directory
error: open of ./MySQL-devel--0.i386.rpm failed: No such file or directory
mysql: unrecognized service


when running

wget http://www.l0rdphi1.com/tools/update.mysql.sh
sh update.mysql.sh

[Rook]

I got this:

error: ./MySQL-server-4.0.23-0.i386.rpm: V3 DSA signature: BAD, key ID 5072e1f5
error: ./MySQL-server-4.0.23-0.i386.rpm cannot be installed
warning: ./MySQL-client-4.0.23-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e
1f5
update.mysql.sh: line 18: service: command not found


Successfully upgraded to MySQL 4.0.23


then I tried v 4.0.24 and it reported:

error: ./MySQL-server-4.0.24-0.i386.rpm: headerRead failed: hdr blob(28095): BAD, read returned 6608
error: ./MySQL-server-4.0.24-0.i386.rpm cannot be installed
warning: ./MySQL-client-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
update.mysql.sh: line 18: service: command not found


Successfully upgraded to MySQL 4.0.24


- I did the wget in the directory I was in at the time (/admin) should I have been in a different directory?

Is there anyway to 'revert' back to the orginal set up?

cheers.

[jmstacey]

smiling_pig,
The script is not downloading a valid rpm (nothing exists on the links you posted), which is what is causing the problem. Make sure that you are inputing a correct version if asked and that the script is not corrupted.
Since I don't mess with rpm's anymore, I haven't kept uptodate on l0rdphi1's script to tell you if it worked or not.


Rook,
To revert, you would simply download the rpm's you used for the last installation/update and reinstall those.

Perhaps at this time it would be wiser to try downloading, installing, and configuring it manually, using the script as reference and making necassary modifications for later use.