RE: Large Data Import

2002-11-21 Thread Lorenzo Curtis
PROTECTED]] Sent: Wednesday, November 20, 2002 10:04 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Large Data Import Well, I've done imports of about 50.000-100.000 posts from other databases. I've gone another way then, and through perl/vi generated a file of mysql command

Re: Large Data Import

2002-11-20 Thread Roger Abrahamsson
Well, I've done imports of about 50.000-100.000 posts from other databases. I've gone another way then, and through perl/vi generated a file of mysql commands that I've then run. Maybe is a bit slower, but you get a complete log in case some things dont work out when you have logging turned on.

Large Data Import

2002-11-20 Thread Lorenzo Curtis
MySQL Gurus: I am working on a process to import data from a VMS database (SJ2) to MySQL. The table that I am importing has 10378507 (over 10 million) records in it. I have the records exported to a comma-delimited text file, as the fields within the database do not contain any commas at all.