Thanks Paul, the options file worked fine! Neil Belch
----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Neil Belch" <[EMAIL PROTECTED]>; "mySQL List" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 2:48 AM Subject: Re: mysqlimport problems > At 0:34 +0100 9/4/03, Neil Belch wrote: > >Hi all, new to the list and new to mySQL... > > > >I've only been at it for a few days and am looking at importing text > >files to databases. > >I'm having trouble with mysqlimport and would appreciate any help or > >solutions as to what I'm doing wrong - I'm sure its a dumb mistake! > > > >I tried LOAD DATA INFILE and it worked fine. Here's the code I used for it: > > > >LOAD DATA LOCAL INFILE 'master_name.txt' > >INTO TABLE master_name > >FIELDS TERMINATED BY ':::' > >ENCLOSED BY '"' > >LINES TERMINATED BY '\r\n' > > > >This works fine. Every record is in the table and all the data is in there. > > > > > >When I try the same thing with mysqlimport, the records are there > >but there's no data in any of the fields! > >The code I used for it: > > > >mysqlimport -L -h localhost -u supercontact -ppassword > >--fields-terminated-by=::: --fields-enclosed-by=\" > >--lines-terminated-by=\r\n contactDB master_name.txt > > > >However, that whole command above won't fit on the DOS prompt in one > >go, so I have to enter most of the options in one command, then the > >remaining ones along with the db name and txt file in a second > >command - it seems to work as the records are still added but > >there's no data. > > Eh? That can't work; you must enter all the arguments in a *single* command. > > You may be able to shorten the command by omitting -h localhost, it > should default to the local host anyway. Or you could put options in > an option file such as C:\my.cnf: > > [mysqlimport] > local > host=localhost > user=supercontact > fields-terminated-by=::: > > etc. > > Of course, if you don't want to use those options the next time you > run mysqlimport, you'll need to remove them from the option file. > > > >(On another note, is there a way to fit the command onto one line in > >the DOS prompt?) > > > >Any help is greatly appreciated. > >Thanks, > > > > > >Neil Belch > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]