Hi,

I'm trying to install MySQL 5.0 on a test server where there has been
no previous version of MySQL installed. I'm using the non-rpm version
and want to install to a non-standard location: /opt/mysql.

I have already updated the PATH to include /opt/mysql

When I try to run the mysql_install_db script I get a series of errors
about /var/lib/mysql. The first one is an error saying it can't
create the /var/lib/mysql directory and then there are messages about
not being able to create test files in that location, then there is a
message saying it can't change to that directory location and finally
a message saying:

Installation of system tables failed!

So I had our sys admin create a /var/lib/mysql directory and had him
give the mysql user permissions in that directory. Then the script
ran to completion but now there are the following directories:
/var/lib/mysql/mysql
/var/lib/mysql/test
and files installed under them. I wanted everything under /opt/mysql/
5.0. Can I move those directories? Was there some other way to force
the mysql_install_db script to use /opt/mysql/5.0?

Many thanks for shedding light on this for me!!
Sarah Anderson

Sarah schreef:
mysql> show variables like '%dir%';
+----------------------------+----------------------------+
9 rows in set (0.00 sec)



or type:
mysqld --verbose --help

before starting to see what variables can be set....


--
Luuk

On May 12, 12:23 pm, Luuk <L... (AT) invalid (DOT) lan> wrote:
Thanks for the response! However, I can't run mysql, it can't find
things because it's still trying to look in other places for the
things that have been installed under /opt/mysql ... so I can't look
at or change the variables you've listed above. If anyone can tell me
if there is something special I need to do in order to install MySQL
to a non-standard location using the tar.gz installation file I'd be
really grateful.

Sarah Anderson

Sarah schreef:
maybe contact your 'sys admin' ? is a good option?

he/she should know what to do...!

--
Luuk