I'm presuming that hard drive space isn't a problem.
What is it you're trying to import that's so large? regular data? graphics?
music? Can you store the files on your hard drive instead and just store
the link in the database? Are the fields, of the table you are importing
too, of an appropriate type?
>
> I am trying to load two tables from space-delimited files.
> Both are quite large.
> Neither ever seems to finish. I have allowed them to run for days.
> The file sizes of the table files increase for a while and stop,
> but the mysql cursor never returns, 'mysqlamysqladmin processlist'
> says the process is still running, top says the process mysql is still
> taking up an entire CPU, but nothing is happening. When this
> happens I can't do anything else in the database.
>
> I have tried LOAD DATA INFILE from the mysql prompt,
> and mysqlimport from the command line (which launches LOAD
> DATA INFILE), both with the same results.
>
> file size
> file 1: 342580425 FAILS
> file 2: 233952880 FAILS
> file 3: 156121911 WORKS
>
> I am running Sun Solaris 8, which allows file sizes over 2gig. Is there
> a file size limit for mysql? Is there some setting I need to
> allow import of large files? Is there some different/better way
> to import data than what I have tried?
>
> The only way I have found to stop the process is to kill the server.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
