Upload problem with phpmyadmin

[Claire DURAND]

Hi,

My mysql base was migrated from a version 3 under Windows to a version 4
under Linux and the base was placed on a new server different from the
web server (this one with phpmyadmin).

When I trie to upload a csv file with phpmyadmin, I obtain the following
error :

---------------
SQL request :

LOAD DATA INFILE 'C:\\WINNT\\TEMP\\php8D.tmp' REPLACE INTO TABLE
`bb_seqesout`
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'

MySQL responds :

Can't get stat of 'C:\WINNT\TEMP\php8D.tmp' (Errcode: 2)
---------------

Is there a problem of path ? (The path must not be /tmp instead of
C:\WINNT\TEMP\ ?)

I tried to modifie in the php.ini the variable UploadDir to "/tmp/", but
it doesn't run too...

Has somebody encoutered the case of parameter setting of phpmyadmin
under windows, on a different server from the mysql base which is under
Linux ?

Sorry for my English.
Thanks for your help.

Hervé C.

[kobi]

Claire DURAND wrote:

Hi,

My mysql base was migrated from a version 3 under Windows to a version 4
under Linux and the base was placed on a new server different from the
web server (this one with phpmyadmin).

When I trie to upload a csv file with phpmyadmin, I obtain the following
error :

---------------
SQL request :

LOAD DATA INFILE 'C:\\WINNT\\TEMP\\php8D.tmp' REPLACE INTO TABLE
`bb_seqesout`
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'

MySQL responds :

Can't get stat of 'C:\WINNT\TEMP\php8D.tmp' (Errcode: 2)
---------------

Is there a problem of path ? (The path must not be /tmp instead of
C:\WINNT\TEMP\ ?)

I tried to modifie in the php.ini the variable UploadDir to "/tmp/", but
it doesn't run too...

Has somebody encoutered the case of parameter setting of phpmyadmin
under windows, on a different server from the mysql base which is under
Linux ?

Sorry for my English.
Thanks for your help.

Hervé C.

Try this sql query:

LOAD DATA INFILE 'c:/WINNT/TEMP/php8D.tmp' REPLACE INTO TABLE
`bb_seqesout`
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'