Select a destination database type to be converted (MySQL or PostgreSQL).

If you select MySQL as a destination database, specify Hostname, Port, Username, Password and use SSH forwarding if needed.

If you select PostgreSQL as a destination database, specify Hostname, Port, Username, Password and use SSH forwarding if needed.

DBConvert for MySQL & PostgreSQL supports Unicode. To make language special symbols displayed correctly select utf8 in the list box "Connection character set". You can also choose any other character set from the list box. After defining necessary information, click "Test connection" button. This will check if it's possible to connect to your MySQL/PostgreSQL server with the parameters you specified before.

In case the connection is set successfully the following message appears and you can continue configuring necessary data:

By pressing "Refresh" button you can view all existing databases available on this server for this user and list them in "Database" combo-box.
Choose a MySQL/PostgreSQL database you'd like to convert. You can also type the name of the database to be converted in this combo it will allow you to save time needed for refreshing information about the bases available.

If you select MySQL Dump as a destination database, you need to do the following:

In "Output file" field enter a name for MySQL Dump (.sql file) to be created. You can also browse it by clicking the button nearby.

In "Database" field enter a name for a database that will be created by the .sql file you specified above. This .sql file will insert data from the Source database to the database with the name you define in "Database" field.

At this step you can set a way the resulting dump file should be formed in. The following settings are available:

MySQL server version - this parameter determines the syntax of MySQL statements being used in output dump file. 'Old' versions of MySQL (before 3.23.6) put more restrictions on database objects names. Note that 'new' syntax is not accepted by 'old' versions of MySQL. Use 'old' syntax whenever you are not sure about your MySQL server version.

Line breaks - this parameter specifies how to separate text lines in the dump file. If your target MySQL server is running on MS Windows platform, you should select 'MS Windows style' option. Otherwise select 'Unix style'.

Insert comments - select this option to add brief comments. It makes the resulting dump file more understandable.

If you select PostgreSQL Dump as a destination database, you need to do the following:

In "Output file" field enter a name for PostgreSQL Dump (.sql file) to be created. You can also browse it by clicking the button nearby.

In "Database" field enter a name for a database that will be created by the .sql file you specified above. This .sql file will insert data from the Source database to the database with the name you define in "Database" field.

If you select MySQL PHP Script as a destination database, specify a destination Hostname, Port, Userame and Password if needed.

In "Output file" field enter a name for PHP Script to be created. You can also browse it by clicking the button nearby.

In "Database" field enter a name for a database that will be created by the PHP Script you specified above. This script will add data from the Source database to the database with the name you define in "Database" field.

At this step you can set a way the resulting dump file should be formed in. The following settings are available:

MySQL server version - this parameter determines the syntax of MySQL statements being used in output Php file. 'Old' versions of MySQL (before 3.23.6) put more restrictions on database objects names. Note that 'new' syntax is not accepted by 'old' versions of MySQL. Use 'old' syntax whenever you are not sure about the version of your MySQL server.



Line breaks - this parameter specifies how to separate text lines in the dump file. If your target MySQL server is running on MS Windows platform, you should select 'MS Windows style' option. Otherwise select 'Unix style'.

If you select PostgreSQL PHP Script as a destination database, specify a destination Hostname, Port, Userame and Password if needed.

In "Output file" field enter a name for PHP Script to be created. You can also browse it by clicking the button nearby.

In "Database" field enter a name for a database that will be created by the PHP Script you specified above. This script will add data from the Source database to the database with the name you define in "Database" field.

     Click "Next >" to continue.