Hi,
I'm upgrading from 4.1.11 to 5.0.51. I have a complication in that we
have two instances of mysql running on one server and this is the
upgrade to one instance and not the other. The software is not
installed in the default location; the tar.gz file was unzipped under
the /opt/mysql/dev/ directory, then a link was created for "5.0".
We're using ports 3306 & 3307. The upgrade was run on the instance
that uses 3307. I have made the necessary changes to my.cnf and the
server is now running. Am trying to run mysql_upgrade as follows
(from the bin directory):
../mysql_upgrade --basedir=/opt/mysql/dev/5.0 --datadir=/ua01/mysqldata/
dev -u root -p --port=3307 --socket=/tmp/mysqldev.sock --verbose > /
opt/mysql/dev/mysqlupgrade_dev.txt

I get the following message:
/opt/mysql/dev/mysql-5.0.51a-linux-i686-glibc23/bin/mysqlcheck: Got
error: 1064: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'FOR UPGRADE' at line 1 when executing 'CHECK TABLE ... FOR
UPGRADE'.

Please help. I've tried all sorts of variations on the command above
but I can't get it to work and I can't find anything about this in the
manual.

I'll be very grateful for any help you can provide.

Sarah Anderson