Is that 100MB made up solely of schema? If you are able to put the files up for FTP/HTTP somewhere, I can try and recreate the problem while profiling memory consumption.
pjjH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hadley Wickham Sent: Saturday, November 24, 2007 6:09 PM To: [email protected] Subject: [sqlfairy-developers] Large SQL files Hi, I was wondering if anyone has any tips on dealing with large (~100 meg) sql files. I get the following out of memory error: Desktop: sqlt -t SQLite -f MySQL mathpeople-imstat.sql > dump-sqlite.sql perl(25882) malloc: *** mmap(size=221171712) failed (error code=12) *** error: can't allocate region *** set a breakpoint in malloc_error_break to debug Out of memory! Thanks! Hadley ------------------------------------------------------------------------ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ -- sqlfairy-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ -- sqlfairy-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
