I have been running mysql 3.23.xx on a few boxes - built from source each time. I now want to upgrade to the new mysql 4 ( http://www.mysql.com/downloads/mysql-max-4.0.html
Firstly I don't see any source files anywhere, so I'm attempting to install the binary version - thinking that it should be much simpler anyway.
So my first step is to move the old mysql tree out of the way
# cd /usr/local/
# mv mysql mysqlold
I then unpack the binary tarball like so:
# tar -zxvf mysql-max-4.0.7-gamma-pc-linux-i686.tar.gz
and I symlink the new mysql tree in place by:
# ln -s mysql-max-4.0.7-gamma-pc-linux-i686 mysql
with all mysql processes killed off, I'm ready to restart the daemon. the result is as follows:
bash-2.05a# ./bin/safe_mysqld &
bash-2.05a# Starting mysqld daemon with databases from /usr/local/mysql/data
030101 21:15:33 mysqld ended
I have tried to reinstall the default databases with the mysq_install_db script, but that dies too. Has anyone ever upgraded in this way, or have you got any ideas?
(happy new year by the way !)