mysql中转储再导入,将MySQL转储导入PostgreSQL数据库

How can I import an "xxxx.sql" dump from MySQL to a PostgreSQL database?

解决方案

Don't expect that to work without editing. Maybe a lot of editing.

mysqldump has a compatibility argument, --compatible=name, where "name" can be "oracle" or "postgresql", but that doesn't guarantee compatibility. I think server settings like ANSI_QUOTES have some effect, too.

You'll get more useful help here if you include the complete command you used to create the dump, along with any error messages you got instead of saying just "Nothing worked for me."