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.
Regards,
Miguel
>Hello guys!
>I'm sorry to report a small problem with the newest MySQL-4.0.0 that
>looks like a bug for me.
>This is a very-very nice and awaited feature DATA/INDEX DIRECTORY in the
>CREATE TABLE statement. On my Win95 it creates .MYD file but
>immediatelly fails in the 1st INSERT statement reporting
>
>g:\mysql-4.0.0\bin>mysqlc ranks < G:\_patrick\test1.sql
>ERROR 1105 at line 32: File '.\ranks\test1.MYD' not found (Errcode: 2)
>
>Line 32 is the first INSERT.
>
>I tried to import an SQL file with
>
>CREATE TABLE test1 (
>...
>)TYPE=MyISAM MAX_ROWS=4294967295 PACK_KEYS=1
> DATA DIRECTORY="G:\\mysql-4.0.0\\data\\r2";
>
>INSERT INTO test1 VALUES ('referer - pages per
>visitor',998092800,1,1,28,38,6,26);
>etc.
>
>The file was created by mysqldump - so, no errors, I just added
>
> DATA DIRECTORY="G:\\mysql-4.0.0\\data\\r2";
>
>Yes, I tried it both in Win32 and forward-slash form like
>
> DATA DIRECTORY="G:/temp";
>
>same error.
>
>And it kinda could not understand any relative path at all
>
> DATA DIRECTORY="./r2";
>gives
>ERROR 1103 at line 11: Incorrect table name './r2'
>
> DATA DIRECTORY="r2";
>gives
>ERROR 1103 at line 11: Incorrect table name 'r2'
>
>In the last two cases even .MYD file has never been created.
>
>That's it.
>
>Thanks... and many thanks - to all of you at Mysql AB
>
>Mike Blazer /Perl developer/
>
>---------------------------------------------------------------------
>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
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ 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
