This page contains answers for the most frequently asked questions regarding PostgreSQL to MySQL converter. If some question is not answered here, please ask Intelligent Converters support team via Feedback Form
What versions of PostgreSQL and MySQL are supported?
All versions of PostgreSQL starting from v9.0 and MySQL hosted on Linux/Unix and Windows
systems are supported. Besides, the product has verified compatibility with MariaDB, Percona
and the following DBaaS variations of DBMS: Microsoft Azure, Amazon RDS, Google Cloud.
Go to Top
How to resolve "The program does not support
authentication protocol requested by server..." error?
The reason of the error is that authentication protocol of the target MySQL
server is not supported by PostgreSQL to MySQL converter. Use OLD_PASSWORD
function to make the user account compatible with PostgreSQL to MySQL database
migration tool. For this purpose, login to MySQL server using administrator
account and run the following statements:
mysql> USE mysql;
mysql> UPDATE user SET Password = OLD_PASSWORD('some_pass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
After this is done, you can use 'some_user' account with PostgreSQL to MySQL
conversion tool.
What are the system prerequisites for the application?
PostgreSQL to MySQL converter works on Windows 7/8/10/11, Server 2008/2012/2016/2019/2022.
Also, the program requires server or client components of PostgreSQL to be
installed on the same machine.
Go to Top
What kind of PostgreSQL data is converted to MySQL?
The application converts table definitions with corresponding attributes, data,
indexes and constraints. It does not convert views, triggers and stored procedures.
Demo version converts only 50 records per table and does not convert foreign keys.
Go to Top
Does PostgreSQL to MySQL migration tool provide
automation feature?
The program does not support automation directly. However, it is supplied
with console version (p2sagent.exe in the installation directory). This
version supports command line arguments and so it can be called from any
script. Write simple batch script calling p2sagent.exe with the appropriate
parameters and you will be able to launch conversion recurrently using
Windows Task Scheduler.
Read Command
line article of the product documentation for more information about p2sagent.exe.
Go to Top
It is possible to connect to MySQL over SSH?
Yes, PostgreSQL to MySQL converter supports connection to MySQL server via SSH.
Please refer to Connecting to MySQL over SSH
article for more details.
Go to Top
How to fix "The ordinal XXXX could not
be located in the dynamic link library LIBEAY32.dll." error?
The error means that the program failed to find at least one of required
libraries. Verify that client or server components of PostgreSQL are installed
on the same machine where PostgreSQL to MySQL database migration tool is running.
Also make sure that the path to PostgreSQL installation folder is in the $PATH
environmental variable. If the problem persists, copy pgs2sql.exe into PostgreSQL
BIN subfolder and try to run it again.
Go to Top
How to resolve error "Access denied for user:
<user-name>"?
You will not be able to connect to the target MySQL server until you have the
appropriate permissions. Ask your MySQL server administrator to give you sufficient
permissions to create new databases on the target MySQL server.
Go to Top
Does PostgreSQL to MySQL converter run on Linux?
Although the program is built for Windows platforms, it can be launched on Linux
with WINE. Learn more details here.
Go to Top
I see the error: "Access denied for user: <user
name> to database <database>". How to handle it?
If the destination database already exists, user must have privileges
to create/delete tables and to write data. If MySQL database does not exist,
user must have sufficient privileges to create new databases on the target MySQL
server.
Go to Top