Configure advanced settings for database connection
dbForge Data Compare for MySQL delivers advanced settings that help fine-tune database connections and reduce traffic.
The following table displays the advanced connection settings you can specify to connect to the MySQL server:
| Setting | Description |
|---|---|
| Connection timeout | Specify how long (in seconds) Data Compare must wait for a response from the MySQL server to open a connection. The default value is 15. Note that zero means an infinite timeout (Data Compare will wait as long as it takes until the connection is established). |
| Execute timeout | Specify how long (in seconds) Data Compare must wait for the query to be executed. The default value is 0. Note that zero means an infinite timeout (Data Compare will wait as long as it takes until the query is executed). |
| Encoding | UTF-8 is the default client connection character set. You can select a different encoding from the list. |
| Detect MySQL character set | When this option is selected, Data Compare automatically identifies the character set used by the MySQL server after the connection opens. |
| Use compression | When this option is selected, Data Compare will use compression when exchanging data with the MySQL server to reduce traffic. |
| Keep connection alive | When this option is selected, Data Compare will ping the MySQL server to validate the status of the open connection. In case the connection is closed, Data Compare will notify you and prompt to reconnect. |
| Ping timeout | Specify how long (in seconds) Data Compare must wait before pinging the MySQL server to validate the status of the open connection. |
Optional: To verify the connection settings, click Test Connection.
Click Connect to create the connection.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for MySQL.
Request a demo
If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for MySQL?