Hi there,
first of all, I am not a mysql goeroe, and know just a little bit about perl DBI.
Now that said, here is my problem.
I have this piece of code: 
use strict;
use DBI;
my $o = DBI -> connect("foo","bar","you wish");

my $dir="/A_Directory";
opendir(DIR, $dir) or die $!;

foreach ( readdir DIR ) {
    next if /^\.{1,2}$/;
    my $file=$dir."/".$_;
    my $query;
    $query="insert into search ( title ) values ( '$file' )";
    print "$query: ",$o->do($query),"\n";
    $query="update search set body = LOAD_FILE('$file') where title = 
+'$file'";
    print "$query: ",$o->do($query),"\n";
    }
closedir(DIR);

$o->disconnect;

[download]
The mysql table search is setup: 
title -> varchar(200) primary key not null
body  -> text
fulltext on title and body
Now, the title is inserted OK, but the body is never inserted. (I also tried to put it all in one sql statement, but got the same problem).

But, when I copy/paste the stdout in the mysql CLI, it works fine.
Am I missing something?

note: perl 561, MySQL 3.23.47
---------------------------
Dr. Mark Ceulemans
Senior Consultant
IT Masters, Belgium

In reply to load_file and mysql by mce

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.