This is one thing I really can't stand about mysql. We should have the option when
creating
databases and tables of specifying where the database is located and the datafile and
indexfile.
Dave
On Fri, Aug 31, 2001 at 07:03:40PM +0200, Simon J Mudd wrote:
> On Fri, 31 Aug 2001, Peter Moscatt wrote:
>
> > Can you change the location of a MySQL database ? The default is
> > '/var/lib/mysql'.
>
> The easy way I've always used is to change the name of the /var/lib/mysql
> directory and make a symbolic link to another directory. You need to
> reset up the mysql database and check the permissions but this at least
> avoids you having to check and/or mess about with the script start up
> options.
>
> There may be better ways, but this works fine.
>
> Regards,
>
> Simon
> --
> Simon J Mudd, Madrid SPAIN. email: [EMAIL PROTECTED]
> Tel: +34-91-408 4878, Mobile: +34-605-085 219
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
