[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
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/