[EMAIL PROTECTED] writes:
> >Description:
> I have installed MySQL version 3.23.36 (having previously used 3.23.34a) After
>I restarted the daemon, I ran the mysql 'monitor' program to check on the existing
>databases and tables. Mysql reported for each table: "Didn't find any fields in
>table 'table-name'". This error had shown up in 3.23.34a for tables that had no
>records (which, since we weren't using them, were removed, which resolved that
>issue). I thought that the tables may have become 'corrupt', so I used "mysql" to
>recreate/reload the tables. The 'index' files were created (and appeared to be
>'filled'), but the 'data' files had only been 'created' when I recieved the error
>"Can not locate file "/index/customer.MYD". "/index" is where the "customer.MYI" is
>located (and pointed to by a symbolic link), while the data portion ("customer.MYD")
>is in "/data" (pointed to by a symbolic link). I would assume that a bug has been
>introduced where the same value of the 'realpath' call for the 'index' portion of th!
e f!
> ile, is being re-used to locate the data portion (instead of another call to get the
>'realpath' of the data portion).
>
> >How-To-Repeat:
> Create a table, and place the index portion (.MYI) in one directory, and the
>'form' (.frm) and data portion (.MYD) in another. Create 'symbolic' links to the
>files from your "/var/databasename" directory, and restart "mysql". Also, create the
>'symbolic' links first (no existing table) pointing to the 2 different directories,
>and try to use 'mysql < load_script' to create the actual files....
>
> >Fix:
> I have place all 3 parts of each table (.frm, .MYD, .MYI) in the same directory
>for now (so I could use the latest version of the "mysql" engine) and redirected all
>'symbolic' links to that area.
>
> >Submitter-Id: [EMAIL PROTECTED]
> >Originator: root
> >Organization: YubbyDubby
> >MySQL support: none
> >Synopsis: MySQL 3.23.36 not resolving 'realpath' to .MYD files.
> >Severity: serious
> >Priority: medium
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.36 (Source distribution)
> >Server: lt-mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 3.23.36
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 16 hours 10 min 27 sec
>
> Threads: 1 Questions: 787 Slow queries: 0 Opens: 22 Flush tables: 1 Open
>tables: 15 Queries per second avg: 0.014
> >Environment:
>
> System: Linux uxdb1 2.2.17-14smp #1 SMP Mon Feb 5 18:40:03 EST 2001 i686 unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 Sep 29 2000 /lib/libc.so.6 ->
>libc-2.1.3.so
> -rwxr-xr-x 1 root root 4101836 Jan 15 07:49 /lib/libc-2.1.3.so
> -rw-r--r-- 1 root root 20273324 Jan 15 07:49 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Jan 15 07:49 /usr/lib/libc.so
> Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db
> Perl: This is perl, version 5.005_03 built for i386-linux
>
Hi!
MySQL treatment of symbolic links in ALTER and REPAIR is documented in
our manual.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
