Hi, I was looking to solution of same problem as Hans Kind. You have suggested to map network drive. Is it O.K.if SAMBA is ruuning on main server. Or can you guide to Documentation for mapping on Linux. I know it is out of topic but it will help me great. Thanks
--- Larry Brown <[EMAIL PROTECTED]> wrote: > If the servers are on the same local subnet, why not > just map a network > drive so both servers have access to the file > locally. > > -----Original Message----- > From: Hans Kind [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 20, 2003 8:22 AM > To: [EMAIL PROTECTED] > Subject: load data in file > > > Hi, > > We have a 2 server setup. 1 server runs the web > server with a PHP > application, the second server is the mysql database > server. > > The php application needs to connect to the mysql > server, to import data > from a text file. For this we use Load Data Infile. > > While everything else in the application works with > regard to connecting to > tge mysql database, when we try to import data we > are getting the following > error: > > Can't get stat of '/upload/wachtbak_cu.txt' > (Errcode: 2) > > We have checked, and the file is indeed uploaded to > the /upload directory > on the web server. However, after the connection is > established with mysql > database, mysql tries to find the file on the mysql > server. > > Question is this. Is it possible to import a file > into mysql, using Load > Data Infile, when you have 1 web server that runs > the php apllication that > imports the data, and 1 mysql database server? > > If that's not possible, is there a way to achieve > this? > > rgds > > Hans Kind > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
