[BlueOnyx:21013] Re: The used command is not allowed with this MariaDB version

[webmaster]

All,


Before an update to the maria 10 db (BX package)

I could upload a file via a web page using


# -- more code above -- #


$host ="localhost"; // Host name
$username="xxxxxxx"; // Mysql username
$password="xxxxxxx"; // Mysql password
$db_name="xxxxxxx"; // Database name
$tbl_name="xreference"; // Table name

mysql_connect("$host", "$username", "$password")or die(mysql_error());

mysql_select_db("$db_name")or die(mysql_error());

mysql_query('TRUNCATE TABLE xreference;');


$sql= "LOAD DATA LOCAL INFILE 
'/home/.sites/106/site3/web/filter_data/fram xref.txt'
INTO TABLE $tbl_name
FIELDS TERMINATED BY '\t'
OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(xmanufacturer, xoemnumber, xframnumber)";


$result=mysql_query($sql)or die(mysql_error());

# -- more code below -- #





Now I get

"The used command is not allowed with this MariaDB version"


I am seeing many fixes via google but... none have worked so far

Anyone point me in the right direction?

Thanks

--Tim