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 <Paul.Harrington@xxxxxxxxxx> 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: sqlfairy-developers-bounces@xxxxxxxxxxxxxxxxxxxxx
> [mailto:sqlfairy-developers-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of
> Hadley Wickham
> Sent: Saturday, November 24, 2007 6:09 PM
> To: sqlfairy-developers@xxxxxxxxxxxxxxxxxxxxx
> 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
> sqlfairy-developers@xxxxxxxxxxxxxxxxxxxxx
> 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/
|
