On 27-May-01 Myke Corredera wrote:
> I just downloaded mysql_3.23.38.tar.gz and I am trying to set it up on an
> i386 FreeBSD 4.3 box. I am trying to get the databases on a diffrent
> partition
> then the program. The current line I used to configure it was
>   ./configure --prefix=/usr/local/mysql --localstatedir=/var/db . I did 
> this because
> I though if I configured it like this the databases would be in /var/db 
> directory and
> not where mysql normally puts them. But to no avail. Could some one please 
> help me
> with this configure problem. Thankx a lot
> 

If you're building from the ports:
localhost.root# make 

You may use the following build options:

        WITH_CHARSET=charset    define the primary built-in charset (latin1);
        WITH_XCHARSET=list      define other built-in charsets (may be 'all');
        DB_DIR=directory        Set alternate directory for database files.

^C
localhost.root# make -DDB_DIR=/where/iwant/data

--- or ---
install per normal, then
mv /var/db/mysql /where/iwant/data
ln -s /where/iwant/data/mysql /var/db/mysql

--- or ---
edit /etc/my.cnf :

[mysqld]
     datadir=/where/iwant/data
---

Regards,
-- 
Don Read                                       [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to