I'm new to MySql but accustomed to Oracle. Hope the below problem report
contains the necessary information.
Output from mysqladmin:
mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386
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.49
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 24 min 15 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 7 Flush tables: 1
Open tables: 1 Queries per second avg: 0.005
Edited output from mysqlbug:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: --help
Subject: Problem with symlinked files used with load data infile
>Description:
When I give an absolute path of a file as argument to LOAD DATA INFILE
I get an errcode: 13 ( Can't get stat of
'/home/reccmo/Musik/IckingArchive/Database/composers.txt') if the
filename path involves a symbolic link, for example
"/home/reccmo/Musik/IckingArchive/Database/composers.txt"
which is symlinked to from
"/music/Musik/IckingArchive/Database/composers.txt"
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
Table definition:
CREATE TABLE Composer (
Id INTEGER(4) NOT NULL AUTO_INCREMENT,
Last_Name VARCHAR(60) NOT NULL,
Sur_Name VARCHAR(60),
Year_Of_Birth INTEGER(4),
Year_Of_Death INTEGER(4),
Country_Code INTEGER(4),
PRIMARY KEY (
Id))
;
LOAD DATA statement:
LOAD DATA INFILE "/home/reccmo/Musik/IckingArchive/Database/composers.txt"
INTO TABLE Composer
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '\''
LINES TERMINATED BY '\n'
(Last_Name, Sur_Name, Year_Of_Birth, Year_Of_Death)
;
Data file content:
'Arcadelt','Jacob',1505,1568
>Fix:
Modify statement to
LOAD DATA INFILE "/music/Musik/IckingArchive/Database/composers.txt"
INTO TABLE Composer
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '\''
LINES TERMINATED BY '\n'
(Last_Name, Sur_Name, Year_Of_Birth, Year_Of_Death)
;
>Submitter-Id: <submitter ID>
>Originator: Christian Mondrup
>Organization:
Christian Mondrup, Computer Programmer
Scandiatransplant, Skejby Hospital, University Hospital of Aarhus
Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark
Phone: +45 89 49 53 01 - http://www.scandiatransplant.org
>
>MySQL support: none
>Synopsis: Problem with symlinked files used with load data infile
>Severity: non-critical
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.23.49 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for
redhat-linux-gnu on i386
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.49
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 30 min 2 sec
Threads: 1 Questions: 14 Slow queries: 0 Opens: 7 Flush tables: 1
Open tables: 1 Queries per second avg: 0.008
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux true 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686
-D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='gcc'
CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Sep 13 18:49 /lib/libc.so.6
-> libc-2.2.5.so
-rwxr-xr-x 1 root root 1260480 Apr 15 15:44 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2310808 Apr 15 16:02 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 15 15:55 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr
--exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include
--libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var
--sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug --without-readline
--enable-shared --with-extra-charsets=complex --with-bench
--localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock
--with-mysqld-user=mysql --with-extra-charsets=all --with-innodb
--with-berkeley-db --enable-large-files=yes --enable-largefile=yes
--with-thread-safe-client --enable-assembler
Best regards
--
Christian Mondrup, Computer Programmer
Scandiatransplant, Skejby Hospital, University Hospital of Aarhus
Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark
Phone: +45 89 49 53 01 - http://www.scandiatransplant.org
---------------------------------------------------------------------
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
