SEO

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:
> 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

mysql> show variables like '%dir%';
+----------------------------+----------------------------+
| Variable_name | Value |
+----------------------------+----------------------------+
| basedir | /usr/ |
| character_sets_dir | /usr/share/mysql/charsets/ |
| datadir | /var/lib/mysql/ |
| innodb_data_home_dir | /var/lib/mysql/ |
| innodb_log_arch_dir | /var/lib/mysql/ |
| innodb_log_group_home_dir | /var/lib/mysql/ |
| innodb_max_dirty_pages_pct | 90 |
| slave_load_tmpdir | /var/lib/mysql/.tmp/ |
| tmpdir | /var/lib/mysql/.tmp/ |
+----------------------------+----------------------------+
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...@invalid.lan> wrote:
> Sarah schreef:
>
>
>
> > 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
>
> mysql> show variables like '%dir%';
> +----------------------------+----------------------------+
> | Variable_name | Value |
> +----------------------------+----------------------------+
> | basedir | /usr/ |
> | character_sets_dir | /usr/share/mysql/charsets/ |
> | datadir | /var/lib/mysql/ |
> | innodb_data_home_dir | /var/lib/mysql/ |
> | innodb_log_arch_dir | /var/lib/mysql/ |
> | innodb_log_group_home_dir | /var/lib/mysql/ |
> | innodb_max_dirty_pages_pct | 90 |
> | slave_load_tmpdir | /var/lib/mysql/.tmp/ |
> | tmpdir | /var/lib/mysql/.tmp/ |
> +----------------------------+----------------------------+
> 9 rows in set (0.00 sec)
>
> or type:
> mysqld --verbose --help
>
> before starting to see what variables can be set....
>
> --
> Luuk

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:
> On May 12, 12:23 pm, Luuk <L...@invalid.lan> wrote:
>> Sarah schreef:
>>
>>
>>
>>> 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

maybe contact your 'sys admin' ? is a good option?

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

--
Luuk