Check the MySQL documentation, but I believe there are 2 ways.
1> In the startup of mysqld, set the datadir option, which tells the mysqld
where the tables are.
2> use UNIX links. Using UNIX links is a good way to split your table and
index I/O across disks. Note that you have to be careful about dropping and
re-creating tables because some versions of MySQL will not follow the links
on re-creation.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jim Josephs, P.Eng
Vice President
WARE Solutions Corp.
#200, 1204 Kensington Road NW
Calgary, AB Canada
T2N 3P5
phone: 403.291.9678 x223
1.877.438.3245
cell : 403.620.7730
fax : 403.283.9670
http : //www.ware-solutions.com
mail : [EMAIL PROTECTED]
WARE Solutions is a publicly traded company on the CDNX:WSN
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: Stephen Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10:19 AM
To: MySQL
Subject: Changing the locations of the tables
Is there a way without reinstalling MySQL to change the locations of
the
database tables?
For example right now they are in
/var/lib/mysql
I want them
/usr/lib/mysql
Thanks in advance
--
****
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
****
-- your next best friend is waiting for you --
---------------------------------------------------------------------
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
