It seems to me that MySql is looking in the wrong dir or it dosn't have permision in data dir ( user mysql.mysql rw permission).
Santino
At 16:46 +0100 7-06-2003, David Leader wrote:
First could I apologize for joining a mailing list primarily to ask for help. However I am not a professional Unix or MySQL manager and am supporting an installation to allow Masters students in Bioinformatics to do summer projects. Last year I managed to install v. 3.23 of MySQL on a Sun box running Solaris 8, but would like to upgrade to 4.0 to be able to use UNION. To put it mildly, I'm having problems. These are two problems.
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
