Re: 24 hour limit for importing .sql data?

On Wed, Apr 18, 2012 at 12:41 PM, Johannes Braunias <johannes.braunias@gmail.com> wrote:

Exactly 24 hours after starting to import a SQL file the import failed.

But only around 20% had been imported by then ...

Is this a timeout which can be changed?

Yes, there is a 24 hour limit.  No it can't be changed.

In general, that's a pretty slow import. 

• How big is the file?
• Was your dump file generated by mysqldump or did you generate it manually?  You need to make sure there is plenty of batching in the file (e.g. 1MB of data per INSERT).
• Are there a lot of indexes?

Thanks,

Ken