[xgab]

Hi!
This is my first experience importing comma, pipe or tabs delimited plain files into a MySQL Database.

I tried using more than one tool and none of them worked...

The thing is that one of the plain files has 250,000 records.

- I tried with a nice freeware script called CSV Importer. It enabled me to import succesfully one plain file of 6,000 records, but the second one has 24,000 and it uploaded only 8,000 (so the largest one will be imposible). Does anyone ever used CSV Importer ? (downloaded from hotscripts.com)

- Then I tried with the latest PHPMyAdmin system. It is very clear how to export information, but I could not figured out how to import!. There is an import link at the little SQL window that asks me for a txt file, but it is not clear how to format and process it.

- I also tried with a Windows freeware to create the .sql file from Access. It created a huge file with many INSERTs. How should I process that big file, thru the little PHPmyAdmin SQL window ???

- Finally I tried with LOAD FROM and mysqlimport, but... unfortunately I get many errors and warnings and the help information at the mysql site is not enough for me... I a newbie :-(

Which is the best option or technique to import large amounts of records ?

The server I use is Linux Mandrake with PHP 4.3.3, the latest MySQL and also my PC is Windows XP.

I will apreciate you help. Than you!

[Mud]

I dont know but I have to say when i try to use phpmyadmin it is a ***** and i HATE IT. I hope you can solve the problem. I feel your pain. Maybe ypu can somehow insert it manually?