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]$