php error

[tomkocz]

I am trying to load data from a file into our mysql database .  The command is  :

LOAD  DATA  LOCAL  INFILE  'C:\Data\HOME\BestShoppers\ProductData\AlabamaNCAAwatches.txt' REPLACE  INTO  TABLE  `products`

FIELDS  TERMINATED  BY  ','

OPTIONALLY  ENCLOSED  BY  '\''

 

I get an error stating the following :

MySQL said:

 

The used command is not allowed with this MySQL version

 

We are running version :

Welcome to phpMyAdmin 2.5.2-pl1

 

MySQL 4.0.18 running on localhost

 

 

Why does this not work?

thanks

[cooldude832]

if the .txt file you stated is a mysql dump file try opening it and copy and pasting into phpmyadmin.

[fenway]

That's likely because you used LOCAL and your my.cnf file doesn't allow it.

[tomkocz]

Still trying to import data from a .txt file. File used to load fine - maybe new version of mysl was installed by our web hoster.

We have file  looks like (this is one row)  :

'','MSS-WAS-TEST','mlb','washingtonnationals','y',4,'<font color=\"cc0000\"><b>Washington Nationals Ladies Sapphire  Series Watch .  </b>  Features:

* Official Team Logo Embossed in Platinum

* Sapphire Crystal Lens

* Stainless Steel Case and Bracelet

* Citizen Quartz Movement

* Water Resistant to 5 ATM (165 Feet)

* Limited Lifetime Warranty ','Washington Nationals Ladies Sapphire Series Watch ','138.00','239.95',1,'<a href="http://www.bestshoppers.com/images/MSS-WAS.jpg"><!--$img %ImageAssetImpl:http://www.bestshoppers.com/images/MSS-WAS.jpg $--><img src="http://www.bestshoppers.com/images/MSS-WAS.jpg" width="140" height="180" border="0"></a><br><font size="1">Click to Enlarge</font>','xx',2005

 

Table Structure looks like :

products

Table comments : stores details about all the products that are available

 

Field Type Null Default

productid  bigint(20) Yes  NULL

Distproductid  varchar(25) Yes  NULL

Sub_Productid  varchar(25) Yes  NULL

Sub_code  varchar(30) Yes  NULL

instock  char(1) Yes  n

distributorid  bigint(20) Yes  0

long_description  text Yes 

short_description  text Yes 

Mycost  decimal(12,2) Yes  0.00

price  decimal(12,2) Yes  0.00

quantity  int(11) Yes  1

imagelocation  text Yes 

htmlcodeforaddtoshopcart  varchar(255) Yes 

timestamp  timestamp Yes  CURRENT_TIMESTAMP

 

Error I get  (when I check the DATA box) :

 

Error

 

SQL-query :

 

LOAD DATA INFILE '/var/tmp/phpdu0tZO' REPLACE INTO TABLE `products`

FIELDS TERMINATED BY ','

ENCLOSED BY '\''

ESCAPED BY '\\'

LINES TERMINATED BY '\r\n'

 

MySQL said:

 

Access denied for user 'tomkocz_test'@'%' (using password: YES)

 

Error I get (when DATA_LOCAL is checked ) :

Error

 

SQL-query :

 

LOAD DATA LOCAL INFILE '/var/tmp/phpwhQMYg' REPLACE INTO TABLE `products`

FIELDS TERMINATED BY ','

ENCLOSED BY '\''

ESCAPED BY '\\'

LINES TERMINATED BY '\r\n'

 

MySQL said:

 

The used command is not allowed with this MySQL version

 

 

 

We are using the GUI interface supplied by our web host provider - version is :

Welcome to phpMyAdmin 2.5.2-pl1

 

MySQL 5.0.22 running on localhost as [email protected]

 

[fenway]

You have not provided any additional information... you don't have access to this command, as per your host's configuration.

[tomkocz]

Hi - what other information would you like me to provide and I take care of that.

thanks

[fenway]

Look here.