将MySQL转储导入PostgreSQL数据库 [英] Import MySQL dump to PostgreSQL database

问题描述

如何从MySQL导入"xxxx.sql"转储到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具有兼容性参数，，其中名称"可以是"oracle"或"postgresql"，但这不能保证兼容性.我认为像ANSI_QUOTES这样的服务器设置也有一定作用.

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."

这篇关于将MySQL转储导入PostgreSQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！