>Description: The following script should insert some files in a table, but load_file seems not to work I think it is only a small error, but I don't find it. Command File: ##################################################################### #!/bin/sh set -exv #Fügt die eingescannten Externbefunde in die Datenbank ein edir=/net/ukh10288/tmpf/externbriefe cd $edir rm -f dofile1 dofile2 2>/dev/null >dofile1 >dofile2 for x in letter*.tif do if [ ! -f $x ] then break fi dname=$edir/$x echo $dname ls -l $dname echo "insert into externbefunde values ('XXX111111X', '1901-01-01', NULL, NULL, 'tif', load_file(\"$dname\"), NULL);" >> dofile1 echo "rm $dname 2>/dev/null" >> dofile2 done # echo "delete from externbefunde where izahl = \"XXX111111X\" and bild is null;" >> dofile1 /usr/local/bin/mysql -v -v -v -B -u db archiv < dofile1 2>&1 sh dofile2 rm dofile1 dofile2 2>/dev/null ################################################################################### The output looks like: ukh3029 ~ [534]$ scan_db.sh #Fügt die eingescannten Externbefunde in die Datenbank ein edir=/net/ukh10288/tmpf/externbriefe edir=/net/ukh10288/tmpf/externbriefe cd $edir + cd /net/ukh10288/tmpf/externbriefe rm -f dofile1 dofile2 2>/dev/null + rm -f dofile1 dofile2 >dofile1 >dofile2 for x in letter*.tif do if [ ! -f $x ] then break fi dname=$edir/$x echo $dname ls -l $dname echo "insert into externbefunde values ('XXX111111X', '1901-01-01', NULL, NULL, 'tif', load_file(\"$dname\"), NULL);" >> dofile1 echo "rm $dname 2>/dev/null" >> dofile2 done + [ ! -f letter0.tif ] dname=/net/ukh10288/tmpf/externbriefe/letter0.tif + echo /net/ukh10288/tmpf/externbriefe/letter0.tif /net/ukh10288/tmpf/externbriefe/letter0.tif + ls -l /net/ukh10288/tmpf/externbriefe/letter0.tif -rwxrw-rw- 1 nobody4 nogroup 2107944 Apr 30 15:46 /net/ukh10288/tmpf/externbriefe/letter0.tif + echo insert into externbefunde values ('XXX111111X', '1901-01-01', NULL, NULL, +'tif', load_file("/net/ukh10288/tmpf/externbriefe/letter0.tif"), NULL); + echo rm /net/ukh10288/tmpf/externbriefe/letter0.tif 2>/dev/null # echo "delete from externbefunde where izahl = \"XXX111111X\" and bild is null;" >> dofile1 /usr/local/bin/mysql -v -v -v -B -u db archiv < dofile1 2>&1 + /usr/local/bin/mysql -v -v -v -B -u db archiv -------------- insert into externbefunde values ('XXX111111X', '1901-01-01', NULL, NULL, 'tif', load_file("/net/ukh10288/tmpf/externbriefe/letter0.tif"), NULL) -------------- Query OK, 1 row affected (0.01 sec) Bye sh dofile2 + sh dofile2 rm dofile1 dofile2 2>/dev/null + rm dofile1 dofile2 ukh3029 ~ [535]$ ############################################################# The database does not store the file: mysql> select * from externbefunde where izahl = "XXX111111X" and rowid = 29856; +------------+------------+------+------+------+------+-------+ | izahl | datum | bem1 | bem2 | typ | bild | rowid | +------------+------------+------+------+------+------+-------+ | XXX111111X | 1901-01-01 | NULL | NULL | tif | NULL | 29856 | +------------+------------+------+------+------+------+-------+ 1 row in set (0.00 sec) mysql> What is wrong, and what should I change? Thank You Dieter >How-To-Repeat: >Fix: >Submitter-Id: <submitter ID> >Originator: Dieter Becker >Organization: Dr. med. dipl.-math Dieter Becker Tel.: (0 / +49) 6841 - 16 3046 Medizinische Universitaets- und Poliklinik Fax.: (0 / +49) 6841 - 16 3043 Innere Medizin III D - 66421 Homburg / Saar Email: [EMAIL PROTECTED] > >MySQL support: email support #791 >Synopsis: load_file in insert >Severity: non-critical >Priority: low >Category: mysql >Class: >Release: mysql-3.23.36 (Source distribution) >Server: /usr/local/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for sun-solaris2.6 on >sparc 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-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 3 days 9 hours 16 min 40 sec Threads: 42 Questions: 315967 Slow queries: 20 Opens: 28773 Flush tables: 7270 Open tables: 1 Queries per second avg: 1.080 >Environment: System: SunOS ukh3029 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-2 Architecture: sun4 Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /d0/workshop/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1607728 Oct 19 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Feb 8 1998 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1014088 Oct 19 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1607728 Oct 19 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Feb 8 1998 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1014088 Oct 19 1999 /usr/lib/libc.so.1 Configure command: ./configure --with-charset=latin1 --with-extra-charsets=all Perl: This is perl, version 5.005_02 built for sun4-solaris --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php