I had various problems upgrading the default fedora install of mysql
3.23.58-9 to mysql 4.0 The following may help others with the same
work to do.
I'll watch this topic for a week or so after 19 Aug 2004, in case there
are questions or suggestion for improvement. I accumulated the script
text that follows from successful commands, just in case I have to
repeat the upgrade on another server, but now I must move on to
other work, so I have not actually executed what follows as a script.
Use it as a guideline at your own risk
A potent aid in getting this work done has been the book
MySQL Admintistrator's Guide, MySQL Press, ISBN: 0-672-32634-5
Strongly recommended, especially if you depend on MySQL in a
production context.
Bill.
# ---------------------------------------------
#
# Download the following rpms from mysql's site
# MySQL-bench-4.0.20-0.i386.rpm
# MySQL-devel-4.0.20-0.i386.rpm
# MySQL-shared-4.0.20-0.i386.rpm
# MySQL-client-4.0.20-0.i386.rpm
# MySQL-server-4.0.20-0.i386.rpm
# MySQL-max-4.0.20-0.i386.rpm
# Ensure that the server is stopped, then remove fedora's
# default mysql-installation
/etc/init.d/mysqld stop
rpm -e mysql-server-3.23.58-9
rpm -e -nodeps mysql-3.23.58-9
# Install the new server
rpm -ivh MySQL-shared-4.0.20-0.i386.rpm
rpm -ivh MySQL-server-4.0.20-0.i386.rpm
rpm -ivh MySQL-max-4.0.20-0.i386.rpm
rpm -ivh MySQL-client-4.0.20-0.i386.rpm
rpm -ivh MySQL-devel-4.0.20-0.i386.rpm
rpm -ivh MySQL-bench-4.0.20-0.i386.rpm
#
# Note: do all the following work before assigning passwords
# to the default user-names created by install of mysql.
#
# Start and quickly test the new mysql server
/etc/init.d/mysql start
/usr/bin/mysqladmin version
# We leave the server running for the Perl dbi re-install, below.
# If it all worked, you should see the 4.0 mysql version information
# on the console.
# Next re-install the Perl database interface (see
#
http://search.cpan.org/~rudy/DBD-mys...e/DBD/mysql.pm)
# When given the option choose auto-configure
perl -MCPAN -e 'install Bundle::DBD::mysql'
# If it all works, you should see successful-install console
# output, followed by successful installation-test results.
# Now run the mysql benchmark/test suites
cd /usr/share/sql-bench
./run-all-tests test
# The tests are a slower, less disk-intensive process than I expected, and
# I was not sure they were running at some points. Anyway I just left them
# running, and every few minutes the tests produce a console line such as
#
# alter table: Total time: 26 wallclock secs ( 0.09 usr, 0.03 sys + 0.00 cusr, 0.00 csys – 0.14 CPU)
#
# The whole suite of benchmark tests took about 40 min
# on my 512Mb, Pentium 4 server.
#
# -------------------------------------------------