import http CSV or TXT to database ???

[snachala]

Is it possible to create a script to import the contence os a CSV or TXT file that is hosted live on the internet straight in to your database without first having to save the file to your computer ?????

If so please could some one point me in the right direction so that i can do it...

[BargainPredator]

This is a very good question. I never tried it but...

If you use java to interact (JDBC connector) I tink you could probably successed by using the P.setBinaryStream(int parameterIndex, InputStream x, int length) or the setAsciiStream(int parameterIndex, InputStream x, int length) functions in the java.sql.PreparedStatement class. Anyway that is waere I would start.

[Endeamy09]

Hi,

Did you notice that MySQL actually supports upload files into database? ie. CSV file.

You can upload your files by using LOAD DATA INFILE

[OlgaShtain]

There is no import function on phpmyadmin anymore. It posed too many problems for users who tried to import their own sql bases. The only thing available which even comes close is to use the big SQL button in phpmyadmin to either copy/paste your sql in bits into your database or import a small txt file... otherwise their is no import feature.