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

asked Apr 22, 2016 at 6:52
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). Commented Apr 22, 2016 at 7:00
  • can u tell me how to edit? Commented Apr 22, 2016 at 8:01
  • The sql file is a text file, you can edit it with any text editor. Commented 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.

answered Apr 22, 2016 at 9:10
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." Commented Sep 19, 2018 at 9:17

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.