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
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.
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.