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!

    If you have a file with a bunch of INSERT INTO statements, you should use the 'source /path/to/file.sql' command in the mysql command line utility to import the records.

      superwormy: I already have a .sql file with all the INSERTs.

      Could you explain me a bit more about the mysql command line utility to import the records ?

        earlparkerii: I already considered SQLyog, but unfortunately it isn't freeware, I cannot pay those $49.

        Does anybody know about a similar utility but freeware ?

          I believe version 3.1 is freeware- double check that, though.

            earlparkerii: I have downloaded version 3.51 from another site and it is freeware!! Thank you!

            I am not at the office now, but I believe I will connect with SQLyog from my Windows XP PC to the Linux server (where I need to import the data) and transfer it thru the LAN...

            Will try this next monday.

            Thank you again!

              I meant version 3.1

                Write a Reply...