Home > Archive > MySQL ODBC Connector > January 2006 > DB Tables on separate hardisks









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DB Tables on separate hardisks
Melvin Zamora

2006-01-26, 4:56 pm

--0-880119588-1138295736=:36418
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi MySql,

Would it be possible to have the PK tables on hardisk-A and FK tables on hardisk-B using only one database?

to envision:

CUSTOMER_MYSQL_DB

CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_T
BL {FK} [HD-B]

-Melvin


---------------------------------
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
--0-880119588-1138295736=:36418--
JamesDR

2006-01-26, 4:56 pm

Melvin Zamora wrote:
> Hi MySql,
>
> Would it be possible to have the PK tables on hardisk-A and FK tables on hardisk-B using only one database?
>
> to envision:
>
> CUSTOMER_MYSQL_DB
>
> CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_T
BL {FK} [HD-B]
>
> -Melvin
>
>
> ---------------------------------
> Bring words and photos together (easily) with
> PhotoMail - it's free and works with Yahoo! Mail.


You can do it symlinks (see the manual for this info.)
HTH

--
Thanks,
James

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

James Harvard

2006-01-26, 4:56 pm

At 1:07 pm -0500 26/1/06, JamesDR wrote:
>You can do it symlinks (see the manual for this info.)


Just in case you are tempted to try _without_ reading the manual, this is only supported for MyISAM tables with MySQL versions >= 4.
http://dev.mysql.com/doc/refman/4.1...-to-tables.html
HTH,
James Harvard

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com