[ic] Accessing another catalog's products table
Kevin Walsh
interchange-users@icdevgroup.org
Thu Aug 22 11:38:01 2002
>
> An alternative - mySQL again - would be to make a symlink to the
> tables you want in the database directory, eg
>
> cd /var/lib/mysql/one_foot_catalog
> ln -s ../two_foot/products.MYI one_foot_products.MYI
> same for MYD and frm
>
I wouldn't do that if I were you. I understand that MySQL uses a read
cache and is therefore very likely to get confused if you modify
one (linked) table while reading from another. You may have locking
issues too.
I never go near the internal MySQL data/index files.
--
_/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
_/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n W a l s h
_/ _/ _/ _/ _/ _/ _/ _/_/ kevin@cursor.biz
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/