dbase->mysql
| From: | Andr�s de la Varga | Date: | Tue, 10 Oct 2000 14:39:30 +0000 |
| Subject: | dbase->mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-19469@lists.php.net to get a copy of this message | ||
I'm trying to put data in mysql from a dbase file,
I generate a .txt from dbase with copy delimited.
From mysql I use,
load data local infile "database.txt" into table mytable
fields terminated by "," enclosed by "\""
lines terminated by "\r\n";
after this only one malformed record is retrived,
Any idea? Other way to put my database in mysql?
Andrés de la Varga