Upload problem with phpmyadmin

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Claire DURAND

    Upload problem with phpmyadmin

    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\\TEM P\\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@cszone.co.il

    #2
    Re: Upload problem with phpmyadmin


    Claire DURAND wrote:[color=blue]
    > 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\\TEM P\\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.[/color]

    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'

    Comment

    Working...