Date |Tue, 31 Jul 2001 16:40:06 -0400
>From |"ROSS MCCORMICK" <[EMAIL PROTECTED]>
Hello!
RM> What about having symbolic links in the same directory as the original file? I
have a situation where a broken Windoze application has different queries embedded,
with some using tablename(lower case), and some using TABLENAME(upper case). The
database actually resides
RM> on a Linux server, so file names, and table names, are case-sensitive. The only
way I could make the app work was to use tablename (lower case) as the original file
name, and create a symlink to it named TABLENAME, in the same directory. Now the app
doesn't complain,
RM> but when I run queries against both tables, I see that the symlinked one doesn't
appear to be updating records, at least not beyond the date that I created the
symlink. It's almost as if MySQL has created a real file from the link, but isn't
updating it. I feel certain
RM> it is not some sort of cache arrangement, because the server has since been
restarted.
RM> Any ideas what might be going on?
I think what symlinks not realy good idea.
You need to correct your code - it's may take some time,
but much less whan if you try to use some ugly hacks like symlinks
and other.
for examle try to use
sed 's/TaBlENaMe/tablename/I'
___________________________________________________________________
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Grigory Bakunov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
