Re: Problem with load data infile and user's privileges

2002-06-15 Thread Jason Englehardt
On Sat, 15 Jun 2002, Sergey Bondar wrote: > OS Linux Red Hat 7.2 > MySql 3.23.41 > > Hi All! > That is my steps. > > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK The user needs the file privilege. Granting all on mydb.* does not giv

Problem with load data infile and user's privileges

2002-06-15 Thread Sergey Bondar
OS Linux Red Hat 7.2 MySql 3.23.41 Hi All! That is my steps. With root privileges I doing: GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; I got: OK With client privileges !!! I doing: mysql -u client -p passwd CREATE DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(

Re: Problem with load data infile and user's privileges

2002-06-14 Thread Paul DuBois
At 20:23 -0400 6/14/02, Sergey wrote: >OS Linux Red Hat 7.2 >MySql 3.23.41 > >Hi All! >That is my steps. > >With root privileges >I doing: >GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; >I got: >OK > >With client privileges !!! >I doing: >mysql -u client -p >passwd >CREATE DATAB

Re: Problem with load data infile and user's privileges

2002-06-14 Thread Galen Wright-Watson
On Fri, 14 Jun 2002, Sergey wrote: > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK > > > Then I doing: > LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; > I got: > ERROR 1045 Access denied fot user: 'client@localhost' (Using

Problem with load data infile and user's privileges

2002-06-14 Thread Sergey
OS Linux Red Hat 7.2 MySql 3.23.41 Hi All! That is my steps. With root privileges I doing: GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; I got: OK With client privileges !!! I doing: mysql -u client -p passwd CREATE DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(

Problem with Load Data InFile

2002-01-27 Thread Hayan Al Mamoun
Dear all, I had a problem with load data infile syntax LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|' that the original data has already carriage returns was considered as new records in the database, I solved it by using the following syntax: LOA

Re: Problem with LOAD DATA INFILE

2001-12-31 Thread David J Jackson
Are you using mysqlimport utility? If not that may be you answer? If so what flags are you setting? david > HI ALL: Happy New Year ;) > I have a text file generated from MSAccess database, one of the > fields (Long Text) have Carriage returns within the text, So > the data of some records f

Problem with LOAD DATA INFILE

2001-12-31 Thread Hayan Al Mamoun
HI ALL: Happy New Year ;) I have a text file generated from MSAccess database, one of the fields (Long Text) have Carriage returns within the text, So the data of some records falls in more than one line in the text file, when I'm using the SQL statement LOAD DATA INFILE... I have only the fir

RE: Problem with LOAD DATA INFILE

2001-10-31 Thread Rick Emery
PROTECTED] Subject: Problem with LOAD DATA INFILE Hello all, I have a problem. I am able to get a copy of a text file which resides on another server for a task I am completing. What I need to do is import this text into a database table on a nightly basis, and I am trying to set this up via PHP so it

Problem with LOAD DATA INFILE

2001-10-30 Thread Michael Benbow
Hello all, I have a problem. I am able to get a copy of a text file which resides on another server for a task I am completing. What I need to do is import this text into a database table on a nightly basis, and I am trying to set this up via PHP so it is all automated. I have one problem tho