Re: dbase->mysql

Also try lines terminated by "\n"; instead of \r\n On Wed, 18 Oct 2000, Jens Kisters wrote: j.kist: Try the PHP - dbase functions, you'll have to compile PHP --with-dbase j.kist: though. j.kist: j.kist: "Andrés de la Varga" schrieb: j.kist: j.kist: > I'm trying to put data in mysql from a dbase file, j.kist: > j.kist: > I generate a .txt from dbase with copy delimited. j.kist: > j.kist: > >From mysql I use, j.kist: > j.kist: > load data local infile "database.txt" into table mytable j.kist: > fields terminated by "," enclosed by "\"" j.kist: > lines terminated by "\r\n"; j.kist: > j.kist: > after this only one malformed record is retrived, j.kist: > j.kist: > Any idea? Other way to put my database in mysql? j.kist: > j.kist: > Andrés de la Varga j.kist: > j.kist: > -- j.kist: > PHP General Mailing List (http://www.php.net/) j.kist: > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net j.kist: > For additional commands, e-mail: php-general-help@lists.php.net j.kist: > To contact the list administrators, e-mail: php-list-admin@lists.php.net j.kist: j.kist: -- j.kist: Grüße aus Weeze j.kist: Jens Kisters j.kist: j.kist: j.kist: rosomm et partner j.kist: Holtumsweg 12 j.kist: 47652 Weeze j.kist: j.kist: Telefon: 0 28 37 - 96 23 73 j.kist: http://www.rosomm-partner.de j.kist: j.kist: j.kist: j.kist: -- ------------------------------------------------ Yurais Fernández Leal, Systems Administrator Public Health Network Santiago de Cuba yurais@medired.scu.sld.cu http://www.scu.sld.cu/ Phone: (53) 226-54204 (home) (53) 226-51556 FAX: (53) 226-54204 ICQ: 33792610 ------------