Mysql Load Data On Server?

[PGG-Tom]

Is it possible to use the mysql

LOAD DATA INFILE

without the LOCAL option

to load text file data from the public side of the site to a mysql table?

 

When I try, I get

#1045 - Access denied for user: '*notmyrealuser*@localhost' (Using password: YES)

 

This would be useful.

I will be getting 10 to 20 M every week via FTP and it is very slow to download/upload, plus it triples the bandwidth consumed (FTP in, my download, my upload).

 

Your help desk has done a requested large file transfer for me before, but this is something I will need to do every few days.

 

[This is a duplicate of my post on a different forum thread, but it saw no response ...]

[TCH-Andy]

HI PGG-Tom,

 

I think you can only do it via a script - if I understand what you want correctly.

 

Phpmyadmin does not support loading the file from the server itself (or at least it didn't last time I checked). However, you can upload the information using a phpscript to load it into the database. Would that help ?