Re: import a .out file - Mailing list pgsql-novice

Yep, it definitely is a SQL dump -- it looks much the same as .sql files
that I'm used to dealing with on MYSQL databases.

Do you have any favorite translator tools that I could look in to?  The file
is massive (58 megs worth) and going through it by hand would be quite
tedious.

I did find this on the MYSQL homepage:
http://solutions.mysql.com/solutions/partner.php?partner=1881&other=1
Suggesting some commercial options are available.  Have any of you used this
tool, or other tools, with success?

Thanks Sean, Sibte, & Richard for your help thus far -- it is most
appreciated!

Jonathon

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Sean Davis
Sent: Friday, September 14, 2007 1:11 PM
To: Jonathon Stierman
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] import a .out file

Jonathon Stierman wrote:
> Forgive my complete lack of knowledge here, but I have a bit of a problem!

>
> I'm in the middle of moving a website from one server to another, and
> it happens to be that POSTGRESQL is not available on the new server
> (MYSQL and MSSQL are the only ones supported).  I have been given a
> .out file which appears to contain PostGre-specific SQL code.  I tried
> importing it directly to MYSQL without success -- I knew it wasn't
> going to be that easy, but I had to try :)
>
> I wasn't able to find anything specific about .out files using the
> search feature on postgresql.org -- is this a standard format for data
dumps?
> What's the best way to import this data, and eventually get it into an
> MSSQL
> (preferred) or MYSQL (if it's easier)?

First, you will have to determine how the ".out" file was produced.  Ask the
person who created it.  It sounds like it might be a database dump.
 If that is the case, you will indeed have some work ahead of you as you
translate all the postgresql-specific stuff into mysql or mssql.  Some of
that can be handled by database tools, but some might need to be done by
hand.

Sean

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate