Thread: mysql2postgres has no documentation?

Dear my friends...

I am trying to nigrate my database from mysql to
postgres.

I have dump my databases qith mysqldump and put the
result in a file ( named basisdata ).

In order to make it be possible to be reloaded with
psql, I want to convert the file with
"mysql2pgsql.perl" tool.

But I don't know the syntax.

I tried this :
"
mysql2pgsql.perl basisdata
"

But lookslike it's wrong.

Anybody would be so nice to tell me which command I
should execute to convert the file into psql familiar
format?

Thank you very much in advance.



__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

> I have dump my databases qith mysqldump and put the
> result in a file ( named basisdata ).
>
> In order to make it be possible to be reloaded with
> psql, I want to convert the file with
> "mysql2pgsql.perl" tool.
>
> But I don't know the syntax.
>
> I tried this :
> "
> mysql2pgsql.perl basisdata
> "
PUT perl IN FRONT OF mysql2pgsql.perl
for example:
[www mysql2psql]$ perl mysql2pgsql.perl
Usage: mysql2pgsql.perl [-v|--h] mysql_dump_file [pg_database_name]

        * mysql_dump_file is the filename of the mysql dump.
        * pg_database_name is the name of the postgres database.
          When ommitted standard output is used.
          Combined with -v, it will tell you what SQL
          commands are being executed
[joe@www mysql2psql]$