2

I having Postgresql dump file like data.sql. I need to convert postgresql file into mysql dump file It is possible to convert without install postgresql database . Thanks in advance

3
  • PostgreSQL and mysql have incompatible features that could not be translatable. Perhaps your best bet would be to edit the file and do any adjustments manually for any incompatible features (e.g. functions, different datatypes, etc). Apr 22, 2016 at 7:00
  • can u tell me how to edit?
    – Chella
    Apr 22, 2016 at 8:01
  • The sql file is a text file, you can edit it with any text editor. Apr 22, 2016 at 8:03

1 Answer 1

1

You can do this using the MySQL Workbench Migration Wizard, which was introduced in MySQL Workbench 5.2.41.

There's a blog post on the MySQL Workbench site here that details how to perform a migration.

Note that it will not be able to migrate more complicated database features.

1
  • 5
    According to a new user Jason, who can't post comments yet: "The above post is not answering the question. The OP wanted to avoid installing Postgresql and wanted to migrate from a dump. MySQL Workbench can only migrate from a running instance."
    – Glorfindel
    Sep 19, 2018 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.