Re: DB Tables on separate hardisks

2006-01-26 Thread James Harvard
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/en/symbolic-links-to-tables.htm

Re: DB Tables on separate hardisks

2006-01-26 Thread JamesDR
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_TBL {FK} [HD-B] -Melvin ---

DB Tables on separate hardisks

2006-01-26 Thread Melvin Zamora
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_TBL {FK} [HD-B] -Melvin - Bring words and photo