Thread:

Hi!

I´m working on a book about the open source DBMS "SAP DB" [www.sapdb.org].
One chapter is reserved for comparison between SAP DB, Postgres and MySQL.

I´ve got a few questions about technical details I can not find in the docs.
The questions are in an excel sheet / star calc document downloadable on
http://www.db-2use.de/sapdb/book/.

It would be very kind if someone could help me or give a url where to find
the informations.

Thanks!

Matthias Suess

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net

> Thanks for your reply regarding my question on how to convert a mysql dump
> into a pgsql dump.
> I have another question.  When I run the mysql2pgsql program, I receive an
> "Out of memory" error.  My mysql dump file is about 672 megabytes.  What do
> you recommend doing to eliminate the out of memory error?

Woof, that's a lot of data. I'm guessing that the mysql2pgsql program
has memory leaks (maybe by design). I'd suggest breaking your dump file
into separate pieces (hard to do with that much data -- maybe try
dumping individual tables?) and reviewing mysql2pgsql for instances
where things are read in and accumulated rather than read/written in
small chunks.

                 - Thomas