Uh, don't symlink. That'll just cause massive amounts of issues later on if
you have to deal with performance (added syscalls to check to valid
symlinks).
If you read the docs on mysql.com, they tell you the command line options
you can set to change the directory. You can put these into my.cnf and
avoid the symlink overhead.
----- Original Message -----
From: "Don Read" <[EMAIL PROTECTED]>
To: "Brian Thompson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 29, 2001 2:08 PM
Subject: RE: space
>
> On 29-Jul-2001 Brian Thompson wrote:
> > I have my /var/ partition set to 400mb, but I need about 4 gigs for a
mysql
> > database im setting up
> >
> > how can I relocate the data files in the users /home directory, or how
can I
> > fix this?
> >
>
> Assume the datadir is /var/db/mysql
>
> make a backup
> shutdown your server (mysqladmin shutdown)
>
> as root :
>
> # mkdir /home/mysql
> # chown mysql /home/mysql
> # cp -Rp /var/db/* /home/mysql
> # rm -rf /var/db/mysql
> # ln -sf /home/mysql /var/db/mysql
>
> restart your server & check for error messages.
---------------------------------------------------------------------
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
