the permissions on the file and the enclosing directory (all the way up
to the root dir) must allow for execution
also, my.cnf need to have
[mysqld]
local-infile=1
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect( "dbi:mysql:databasename", 'user', 'password', {
PrintError => 0 } ) or die "Can't connect to mysql database:
$DBI::errstr\n";
$input = "load data infile '/users/hcir/p99x/palmer/last/trk' into
table trk";
$dbh->do($input) or warn "$DBI::errstr\n";
$dbh->disconnect or print "Disconnect failure: $DBI::errstr\n";
- hcir
On Monday, Oct 7, 2002, at 18:51 America/Anchorage, Ronald Petty wrote:
> I just tried the following and got
>
> ysql> load data local infile "/home/repett0/contact.data" into table
> CONTACT;
> ERROR 1148: The used command is not allowed with this MySQL version
> mysql>
>
> I too use perl and dbi
>
> What is going on?
---------------------------------------------------------------------
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
