UBBFriend: Email This Page to Someone!

DevShed Discussion Forums   MySQL   85 million record import    profile | register | preferences | faq | search

Author	Topic:   85 million record import
majorbytes Junior Member	posted June 10, 2000 11:23 PM             I am currently working on a project that has tons of records that I am importing into MySql. Has anyone here ever done this?? And if so what were the results? ------------------ Man, that was fast!
alexgreg Member	posted June 11, 2000 11:30 AM             I'm in a similar situation, but with only 14,000 records. If they're already in a structured format like an HTML table it's possible to feed in the file name to a PHP program and have that program add the records to a mySQL database. But I have no experience in this. Sorry.
majorbytes Junior Member	posted June 12, 2000 07:02 AM             I use LOAD DATA INFILE to import them into MySQL and it works okay. I am importing in 150meg increments.

All times are MST (US)	next newest topic | next oldest topic
Administrative Options: Close Topic | Archive/Move | Delete Topic
	Hop to: Select a Forum List of Forums: ApacheBeginnersSecurityOpen Source DiscussionXMLWAP/WMLPostgreSQLBanner AdvertisingExchange/OutlookGraphicsHTML / DHTMLJava ServletsJavaScriptMidgardMySQLPHPPerlPythonSearch EnginesWeb HostingZope

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.