Have You deleted or updated te my.cnf file?
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]