1. The upgrade instructions do not say anything about how you upgrade your old database. Section 2.3.2 of the manual only talks about things such as running things like mysql_fix_privilege_tables. From asking around I gather you are expected to use mysqldump to transfer databases, however I am totally in the dark as what stage of the new install you add the old tables.
2. In addition, I am having difficulty (this weekend - it was ok last weekend but then I scrapped it and went back to 3.23) in starting mysql 4.0 after doing an install. I did an mysqldump on 3.23, shut down the old server, and changed the mysql directory name to mysql3.23. I follow the instructions in 2.2.9, run scripts/mysql_install_db and check that the grant tables have been created in data. However when I try bin/safe_mysqld --user=mysql the daemon starts and then quits. The .err log says it can't find host.frm, but the file has definitely been created. I've installed the distribution as /usr/local/mysql - so everything would appear to be in the standard location.
I'd be most grateful for any suggestions on either point.
David
-- _______________________________________________________________ David P.Leader, Biochemistry and Molecular Biology Davidson Building, University of Glasgow, Glasgow G12 8QQ, UK Phone: +44 41 330-5905 [EMAIL PROTECTED] http://doolittle.ibls.gla.ac.uk/leader _______________________________________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]