I get this error:

Access denied for user: '1112185271@%' (Using password: YES)

Where using this code:

LOAD DATA INFILE 'feeds/****/CategoryMappings.txt' INTO TABLE pd_shopping_categories

everything is there and should work, yet dosen't. The same db connection code is used as is used elsewhere on my site, and that error dosen't seem to come up. In phpmyadmin the same error comes up.

Any clue as to what is causing it?

Thanks
Tom

Has the user got all the permissions for that table?
Have you tried it with localhost being the user?

If that is not what is up, can you please tell us more about what the problem is as this may help us to help you.

You have to grant permission to that user to perform that operation.

Originally Posted by cptnwinky

You have to grant permission to that user to perform that operation.

erm... ok, thanks. The point is its a "Rented" server, rented for free. But I will speak to my host!

Thanks

Hi.. is there any way of doing this a different way? Maybe using fwrite or anything?

Yes you can read the contents of the file and as long as it is a standard dump file (in other words proper sql syntax) then you can just run the text as any other query.