in reply to Load csv file to mysql server

What is the exact error that you are getting? Also, have you tried to run the 'load data' command from the command-line of the Windows box and did it work?

Replies are listed 'Best First'.
Re^2: Load csv file to mysql server
by afoken (Chancellor) on Jul 27, 2009 at 13:12 UTC

    The error message would really be useful. The LOAD DATA command has several security restrictions, so it may be simply a permissions problem.

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
      hi, if i use heidiSQL client it is upload from local system to mysql server using same user id and password .then how it is permission problem

        I did not say that it IS a permission problem. I said that it MAY BE a permission problem. Do you understand the difference between the terms "is" and "may be"? "is" means that I am sure. "may be" means that I think it is possible, but I am not sure.

        Now we know that it is unlikely a permission problem. There must be a different error. The error message will tell us what went wrong. Show us the error message and we will help you. Keep the error message secret and we can't help you. It's that simple. Help us helping you or go away.

        If you have big problems explaining your problem in english, tell us and we can switch to a different language that is easier for you.

        Alexander

        --
        Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)