Hi!
>>>>> "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes: Mike> Miguel Angel SolŐrzano wrote: >> >> At 14:24 24/10/2001 +0400, Mike Blazer wrote: >> Hi Mike, >> >> Thanks for the bug report. >> The explanation why the insert command doesn't works on Win32, >> is because the link file pointing for the DATA DIRECTORY wasn't >> created in the create table command, like the Unix version does. >> The Win32 OSs don't have a native symbolic link feature and the >> today symbolic link support on Win32 is made creating a plain text >> file with the extension *.sym on \data directory and contains the >> path of the whole database. >> Then DATA DIRECTORY feature should be handled in a different way >> on Win32 than is made on Unix. Mike> Thanks, Miguel, I see - but I don't believe that nothing could be done Mike> for Win32. There are explorer shortcut files with the set of Win32 API Mike> calls to read/write them - so, I guess not only directories(databases) Mike> but .MYD and .MYI files could be linked separately. Mike> OK, in fact you could use table_name.MYD.sym and table_name.MYI.sym in Mike> the same way you are using database.sym now - there is a Change/Notify Mike> mechanism that avoids the need to read that .sym files more then once if Mike> they are not changed. But ALTER TABLE and OPTIMIZE TABLE should not Mike> destroy this fake symlink. Mike> Well, I'm sure there are some better ways too - it's a pity that it such Mike> a useful feature fails on Win32. I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY directives, until we have come up with an acceptable workaround for windows. For the moment, I can't come up with any better solution than to also start supporting .sym files on windows; We plan to in the near future generalize the file handling interface in MySQL; When we do this, we will take this into consideration! Regards, Monty --------------------------------------------------------------------- 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
