Description:
Hi!
I try to load some data using
LOAD DATA LOCAL INFILE
from client station to server.
It's working if the file is on the server machine.
It's not working if the file is on the client machine.
my.ini file is:
****************************************
[WinMySQLAdmin]
Server=D:/MYSQL/bin/mysqld-opt.exe
user=curs04
password=asdfghjk
QueryInterval=10
[mysqld]
basedir=D:/MYSQL
#bind-address=10.176.12.94
datadir=D:/MYSQL/data
#language=D:/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#local-infile=1
****************************************
Thank you
Razvan Stroe
How to repeat:
'I have a database "birpr" and a table "presa" with a field "fld1"(longtext)
'I have an *.asp file
'*********************************************
<%@ Language=VBScript %>
<%
strDSN = "DRIVER={MySQL};DATABASE=birpr;SERVER=;UID=;PORT=;OPTION=0;STMT=;"
Set cn1 = Server.CreateObject("ADODB.Connection")
Set rsCustomers = Server.CreateObject("ADODB.Recordset")
cn1.Open strDSN
strSQL = "LOAD DATA LOCAL INFILE 'c:\\my.txt' INTO TABLE presa FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'"
rsCustomers.open strSQL, cn1
Response.Write "ok"
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
ok
</BODY>
</HTML>
'*********************************************
'the error message is
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]File 'c:\my.txt' not found (Errcode: 2)
/bir_pr/adm1.asp, line 9
'*********************************************************
Suggested fix:
...?
Description: Hi! I try to load some data using LOAD DATA LOCAL INFILE from client station to server. It's working if the file is on the server machine. It's not working if the file is on the client machine. my.ini file is: **************************************** [WinMySQLAdmin] Server=D:/MYSQL/bin/mysqld-opt.exe user=curs04 password=asdfghjk QueryInterval=10 [mysqld] basedir=D:/MYSQL #bind-address=10.176.12.94 datadir=D:/MYSQL/data #language=D:/MYSQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M #local-infile=1 **************************************** Thank you Razvan Stroe How to repeat: 'I have a database "birpr" and a table "presa" with a field "fld1"(longtext) 'I have an *.asp file '********************************************* <%@ Language=VBScript %> <% strDSN = "DRIVER={MySQL};DATABASE=birpr;SERVER=;UID=;PORT=;OPTION=0;STMT=;" Set cn1 = Server.CreateObject("ADODB.Connection") Set rsCustomers = Server.CreateObject("ADODB.Recordset") cn1.Open strDSN strSQL = "LOAD DATA LOCAL INFILE 'c:\\my.txt' INTO TABLE presa FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'" rsCustomers.open strSQL, cn1 Response.Write "ok" %> <HTML> <HEAD> </HEAD> <BODY> ok </BODY> </HTML> '********************************************* 'the error message is Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]File 'c:\my.txt' not found (Errcode: 2) /bir_pr/adm1.asp, line 9 '********************************************************* Suggested fix: ...?