| Author |
Problem with symbolic link
|
|
| Vlad Shalnev 2005-09-16, 3:24 am |
| Hi all
Problem description
OS: Solaris 9
Mysql: 4.1.8
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".
If someone solve this problem let me know please.
Thanks for any help
--
--------------------------------------------------------------------------------
Vlad A. Shalnev
E-mail: vlad@asv.ru
"Gravity can't be blamed
for someone
falling in love"
( Albert Einstein )
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Jasper Bryant-Greene 2005-09-16, 3:24 am |
| 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?
--
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/mysql? unsub...sie.nctu.edu.tw
| |
| Vlad Shalnev 2005-09-16, 7:23 am |
| I have two configuration database for my application and I need to have some
tables with same data and some tables with different data.
Jasper Bryant-Greene wrote:
> Vlad Shalnev wrote:
>
>
>
> 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 A. Shalnev
E-mail: vlad@asv.ru
"Gravity can't be blamed
for someone
falling in love"
( Albert Einstein )
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Jasper Bryant-Greene 2005-09-16, 7:23 am |
| > Jasper Bryant-Greene wrote:
>
Vlad Shalnev wrote:[color=darkred
]
> 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/mysql? unsub...sie.nctu.edu.tw
| |
| Gleb Paharenko 2005-09-16, 8:23 pm |
| Privet!
Usually there is a number in the brackets after an error message. What
is this number?
Vlad Shalnev <vlad@asv.ru> wrote:
> Hi all
>
> Problem description
>
> OS: Solaris 9
>
> Mysql: 4.1.8
>
> 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".
>
> If someone solve this problem let me know please.
>
> Thanks for any help
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|