This is just my experience.

But if you are doing this sort of work, it may well pay to construct your own import program. There are many ways of doing this, like parsing an email message, or using a XML/SOAP server. This will probably pay on the long run, as you can introduce filters, data checks, security and pre-processing.

Ben.

Paul Kruger wrote:

Hello..
Im a new sql user so if this is a common prob Please be kind
Im trying to set up mysql 4.0.13
With a database that contains 60k records…
The client wants to import 60000 records a week
With near 4mill records in a database…
My problem is I don’t want to give ssh access to
The machine…
So iv tried phpmyadmin
And access to import the data but it seems to get to 40k records
And then fails or times out…
What methods do you all use to import super large amounts of data?
Thanks in advance
Paul


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 5/22/2004




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to