Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Unanswered: load file problem

    Hi,

    i'm trying to load a csv file into my mysql database, but i've have a problem/

    Mysql is built on Localhost server, an my file is localised on this path 'C:/SRM/SRM.csv'

    i've try this command without sucess :

    LOAD DATA INFILE 'C:/SRM/SRM.csv' INTO TABLE `PERIODES` FIELDS TERMINATED BY ','

    MySQL a répondu:


    Access denied for user: 'srm@localhost' (Using password: YES)
    could you me please?

    How can write a bacth process for execute automatically this transfert
    script?

    THANK YOU
    Patrick .T

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    make sure that srm@localhost user add the insert and the file privileges
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jul 2003
    Posts
    4
    Originally posted by omiossec
    make sure that srm@localhost user add the insert and the file privileges
    i've the all the privilige, but it's the same problems

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •