MySQL 4.0.21

jmstacey

Verified User
Joined
Feb 12, 2004
Messages
4,106
Location
Colorado
MySQL 4.0.21 was released

l0rdphi1's MySQL update tool for Redhat
Code:
wget [url]http://www.l0rdphi1.com/tools/update.mysql.sh[/url]
sh update.mysql.sh

My update tool for FreeBSD 4.x
Code:
fetch [url]http://www.saevian.com/da_tools/update.mysql.sh[/url]
chmod 755 update.mysql.sh
./update.mysql.sh
 
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
 
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
 
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] [email protected] [/usr/local/etc/rc.d]
/lib/libcrypt.so.2: Undefined symbol "_CurrentRuneLocale"
>


i've theese two errors, help me please
 
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
 
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
 
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!
 
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 ;)
 
Last edited:
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.
 
Last edited:
jjma said:
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
 
Last edited:
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.
 
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
 
Back
Top