id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,port
10566,mysql5 mysql_upgrade doesn't work after upgrading to 5.0.24,ryandesign@…,ryandesign@macports.org,"I understand you're supposed to run mysql_upgrade after you upgrade to a new version of MySQL. But after upgrading to MySQL 5.0.24, mysql_upgrade doesn't seem to work anymore.

(I have /opt/local/bin, /opt/local/sbin and /opt/local/lib/mysql5/bin in my PATH.)

{{{
$ mysql_upgrade5
Can't find program '/opt/local/bin/mysqlcheck'
Please restart with --basedir=mysql-install-directory
$ mysql_upgrade                    
Can't find program '/opt/local/bin/mysqlcheck'
Please restart with --basedir=mysql-install-directory
$ mysql_upgrade --basedir=/opt/local/lib/mysql5/
Can't find data directory. Please restart with --datadir=path-to-data-dir
$ mysql_upgrade --basedir=/opt/local/lib/mysql5/ --datadir=/Users/rschmidt/mysql/data/
[snipped usage message for mysqlcheck]
Could not find file mysql_fix_privilege_tables.sql
Please use --basedir to specify the directory where MySQL is installed
$
}}}

I don't know what to specify now. And it seems to me like I shouldn't have to specify anything -- that it should already know where its parts are. In 5.0.22 the script worked fine without specifying anything extra, but I read in the release notes that between 5.0.22 and 5.0.24 they rewrote mysql_upgrade and changed it from a shell script to a C program. I'm guessing that has something to do with this problem.",defect,new,Normal,,ports,1.3.2,,,jberry@… markd@…,"mysql5, mysql5-devel"