Jasper Bryant-Greene wrote:
Vlad Shalnev wrote:
Periodically I get error message "can't get stat of xxx.MYD" for
tables that are symbolic link to tables on different database on
the same file system. Error disappear after executing "flush
tables".
Why are you doing this? You can access tables in other databases in
your SQL queries so what is the point of making symbolic links to
tables in other databases? Is it even supported?
Vlad Shalnev wrote:
I have two configuration database for my application and I need to
have some tables with same data and some tables with different data.
So why not just reference the tables that need to be the same with a
fully-qualified name?
Like:
SELECT * FROM databasename.tablename WHERE a=439 LIMIT 1
or whatever. There's no need to do symbolic links for that...
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
