
In emails, please include the Postgres code, and the expected MySQL code Yes it discards ALL queries except for CREATE TABLE and INSERT INTO Php pg2mysql_cli.php /path/to/pd/dump/file.sql /path/where/to/save/mysql/file.sql Sudo -u postgres pg_dump -format p -inserts DBNAME_HERE > /path/to/file.sql sql format, make sure you use "-format p -inserts" Sudo apt install php7.4-cli (in case of our modified script)ģ. Unzip pg2mysql-1.9.zip (in case of our modified script for php version 7.4)

Tar -xvf pg2mysql-1.9.tar.bz2 (in case of original script from the author) Wget (contains our modified script for php version 7.4) Wget (contains original script from the author) Download the script and unpack the archive However, use is still on own risk, and we provide NO GUARANTEES whatsoever.ġ. We did make our own modifications to the tool to make it work with php 7.4. Free option - pg2mysql php scriptĭisclaimer: This tool was developed by a third party => it is NOT a product of Easy Software, and therefore is NOT GUARANTEED.

The others were premium tools, with results that, in our opinion, make it worth the purchase. One is a free open-source, but also older and with a significant disadvantage. For the sake of you, Easy Redmine server admins, we have tested a couple of tools for DB migration from Postgres to MySQL.
