It's mostly data. Does that change anything? I can put most of the data up (95% is from one table). Is there an easy way to split up the one monolithic file into one for each table?
Hadley On Nov 25, 2007 8:08 AM, Harrington, Paul <[EMAIL PROTECTED]> wrote: > 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 > -- http://had.co.nz/ ------------------------------------------------------------------------- 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
