Upgrading MySQL 3.x to 4.x on Mac OS X - oddities?

[bunner_bob]

I just upgraded to MySQL 4.1.21 from 3.something (reasonably recent) using Marc Liyanage's guide at entropy.ch. A couple of things didn't work for me:

1. I was supposed to run some commands to "restore the old data" before rebooting. The last command was "sudo chown -R mysql /usr/local/mysql/data/*", but I got a "file not found" error.

2. After rebooting (and with MySQL running) I attempted to convert the MySQL privilege tables by entering "mysql_fix_privilege_tables --[password]" in terminal (bash) and got the error "command not found".

Everything seems to be working fine as far as I can tell, but I don't like it when something doesn't do what it's supposed to. Any advice? Am I ok or should I do something?

Thanks!

• Bob

[bunner_bob]

Update - finally figured out that I had to type in the full path to mysql_fix_privilege_tables, so it looked like this:

/usr/local/mysql/bin/mysql_fix_privilege_tables --password=mypassword

Still don't know about the first question but as I said, everything's working so I'm not going to sweat it.