in reply to Re: Load csv file to mysql server
in thread Load csv file to mysql server

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". ;-)

Replies are listed 'Best First'.
Re^3: Load csv file to mysql server
by Anonymous Monk on Jul 27, 2009 at 16:01 UTC
    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". ;-)