Re: dbase->mysql

Hi Andrés: > From mysql I use, > > load data local infile "database.txt" into table mytable > fields terminated by "," enclosed by "\"" > lines terminated by "\r\n"; MySQL's load data and mysqlimport commands are pretty particular about what they want to see. Some ideas, but no guarantees... use single quotes rather than doubles, try dropping the "lines terminated by" line which will use the default '\n', perhaps there's some unescaped quote marks or commas inside a field of your text file... If that doesn't fly, reformat your dump from the other database to conform with the load data parameters. If your further hacking doesn't work, this is really a MySQL question so should be looked up on the MySQL mailing list archive, then, if no answer is found, posted to the list. I suspect this question has been asked several times, so the archive should have some help for you. -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409