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.
--
Arno Coetzee
Developer
Flash Media Group
Office : +27 12 342 3490
Mobile : +27 82 693 6180
Fax : + 27 12 430 4269
www.flashmedia.co.za
<<FMG Total messaging solution. For all your GSM (SMS and USSD) messaging needs.
Quick and easy do-it-yourself interfaces. http://www.flashmedia.co.za/tms.php >>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
