#10566: mysql5 mysql_upgrade doesn't work after upgrading to 5.0.24 --------------------------------------+------------------------------------- Reporter: ryandesign@macports.org | Owner: ryandesign@macports.org Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.3.2 Resolution: | Keywords: Port: mysql5, mysql5-devel | --------------------------------------+------------------------------------- Changes (by ryandesign@macports.org): * cc: ryandesign@macports.org (removed) * reporter: opendarwin-2006@ryandesign.com => ryandesign@macports.org * port: => mysql5, mysql5-devel Old description:

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.

New description: 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. -- -- Ticket URL: <http://trac.macports.org/ticket/10566#comment:9> MacPorts <http://www.macports.org/> Ports system for Mac OS