-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Arno Coetzee wrote:
> Test USER wrote:
>
>> Can't get this to work, but i would like to specify LOAD DATA to use
>> an INFILE from an URL.
>>
>> For example
>> LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv' But i get
>> an error message saying file not found.
>>
>> Anyone know if this is even possible ?
>>
>> -------------------------------------------------
>> FREE E-MAIL IN 1 MINUTE!
>> - [EMAIL PROTECTED] - http://www.pc.nu
>>
>>
>>
> it is possible .
>
> you have to write your own script which fetches the file (using wget)
> and placing the file in a directory where it can be accessed. then you
> can load that file.
>
> i currently have something like this running...
>
> i make a dump file on the remote server runing a script with crontab. i
> gzip that file just to make the file transfer faster . the local server
> then fetches the file (wget) and gunzips it and then i load the file.
> works pretty good.
>
The JDBC driver, and the "mysqli" interface for PHP support this for
"LOAD DATA LOCAL INFILE", check the documentation for each if this is an
option for you.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDlGOEtvXNTca6JD8RAlGyAJwNUa73auCDBjIyib7ikIBrUb1vsQCfUPV5
eoaYiyOOX4T3YVEuOrjj+9A=
=/wQd
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
