Online Documentation for Data Comparer for MySQL
Step 1 - Setting connection properties
At this step you should specify necessary settings to establish connection to MySQL databases.
First select the connection type: local or remote.
Local connection is used to connect to MySQL server launched on the same machine where Data Comparer for MySQL is running.
The Remote mode allows you to connect to MySQL server launched on another computer in the network.
By default the program uses local connection. It is indicated by switch Local selected. If you wish to establish remote connection, you should select the Remote switch. For remote connection you should also enter MySQL host name in the Host field. For both types you should enter MySQL port to connect through in the Connection port field.
Afterwards you should specify authorization settings: Login and Password.
The default superuser name is 'root' and the default password is empty.
If necessary, use the drop-down list to specify the preferable Client charset to be used by the application.
After that it is necessary to specify the database you are going to work with: type in its name in the Database field or use the ellipsis button to select one from the Select database list.
Please note that you need to have sufficient privileges to be able to write to the destination database on MySQL server.
To setup the connection via SSH tunnel proceed to the Tunneling tab and input the following values in the corresponding fields:
- SSH host name is the name of the host where SSH server is running
- SSH port indicates the port where SSH server is activated
- SSH user name stands for the user on the machine where SSH server is running (Note: it is a Linux/Windows user, not a user of MySQL server)
- SSH password is the Linux/Windows user password
For details see SSH tunneling options.
To use HTTP tunneling, just upload the tunneling script to the webserver where MySQL server is located, or to any other webserver from which direct connections to your MySQL server are allowed. This script exposes the MySQL API as a set of web-services which is used by Data Comparer for MySQL.
For details see HTTP tunneling options.
Repeat the steps above for the target MySQL connection or just check the Both databases on the same server option for comparing data from databases located on the same server.
When you are done, press the Next button to proceed to the next step.