Re: Importing large text file

2002-01-03 Thread Steve Rapaport
Greg, I agree with Tom H. PHP can also do an excellent job of this, even as a standalone script (ie no web server interaction). And you won't have to figure out how to load the DBI module! I'll adapt an example from something else I did: (Warning, not tested code...) #!/usr/local/bin/php Greg

RE: Importing large text file

2002-01-03 Thread Haapanen, Tom
, 2002 16:33 To: [EMAIL PROTECTED] Subject: Importing large text file This is my first post on this list, so bear with me. I have a text file with 10,000 stories in it (about 130 MB). I would like to break it up into 10,000 separate files and am trying to figure out a way to feed it into a MYSQL

Importing large text file

2002-01-03 Thread Greg Peretti
This is my first post on this list, so bear with me. I have a text file with 10,000 stories in it (about 130 MB). I would like to break it up into 10,000 separate files and am trying to figure out a way to feed it into a MYSQL database. I have set up the database with the pertinent fields, excep