Hi,

Has anyone had any problems using the upload method of importing data?

Or can anyone explain how it works, for example does it read all the data before importing or does it "stream" it or does it upload the file and then import?

The reason I ask is because myself and someone else are trying to upload a 92MB dump but nothing seems to be happening. It has been going 30 minutes. The file is being uploaded on a 512kbps cable modem.

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

I've had no problems with smaller files like around 2 or 3 MGs...probably a problem with CPU/Memory usage. It may be better to simply use the mysqlimport function via telnet for larger files...

Regards,

Eliot Lee

Yeah that was the problem though. It is not my server it is the other persons and they don't have telnet access so we are kind of in a pickle.

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

One suggestion is to break up the file into smaller segments and then "upload"/import the individual files.

Regards,

Eliot Lee

Ah yeah, forgot about that.

I have three tables in the dump that are split about 40 : 40 : 20

So that means if I dumped each table seperately it would be about

38MB : 38MB : 18MB (or whatever)

Do you think that would still be too big.....I have a feeling it might.....

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

Hi Paul,

Can you not split up your inserts into separate files as well if the 3 files are still too large? i.e. Make one file to create the tables and then split the up the inserts into 5, 10, 20... however many files you may need. It's a lot of cut & paste but it sounds like that is your only option.

Regards
~Charlie

Thanks piper, I will see how we go with 3 dumps and go from there.

Before that though I need to sort out a darn mysql error.



Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/