MySQL Server Page - Automatic Backup Scheduler for MySQL
Task Wizard
Automatic Backup Scheduler for MySQL > Help Document > Task Wizard > MySQL Server Page

MySQL Server Page


Enter the connection information of the source or destination MySQL server.
MySQL Server

Click here to read more about how to connect to a MySQL server

  1. Connections: All of the MySQL server connections you have created are in the list.
    1. You can select an existent MySQL server connection from the connection list and the information will be filled in the General options on the page automatically. You can still change the MySQL server information on the page manually. You can add MySQL server connections to the connection list if you'll often use it.
    2. After setting up the General options of a MySQL server, you can click Save Connection button to save the MySQL server connection into the connection list. The password will be hidden and replaced by '*', so please don't worry about the password may be leaked.
  2. General:
    1. Host Name or IP Address: The host name ( e.g. www.databasethink.com ) or IP address ( e.g. 127.0.0.1 ) of the MySQL server.
    2. MySQL Port : The port of the MySQL server, the default port is 3306.
    3. Username: The name of the user on the MySQL server.
    4. Password: The user's password on the MySQL server. Leave it blank if the user has no password.
    5. Default Character Set: You can select or enter the name of a character set. It's used for non-English ( German, French, Italian, Russian, Chinese, Japanese, Korean, etc. ). It includes Unicode, UTF8, etc. The default value ( Automaticlly detect ) is recommended.
    6. Compression Protocol: Check the option to use the compressed client / server protocol to connect to a MySQL server, if the server permits compression connections. It's used to reduce network traffic.
    7. SSL Protocol: Check the option to use SSL protocol to connect to a MySQL server, if the server permits SSL connections. It allows you to establish secure network connections. Click Settings to set up the SSL options, including Certificate Authority file, Certificate Authority directory, Key file, etc.
    8. SSH Tunneling: Check the option to use SSH tunneling to connect to a MySQL server, if the server permits SSH connections. It allows you to establish secure network connections. Click Settings to set up the SSH options, including SSH host, port, username, password, key, etc.
    9. Shared-Memory Protocol: Check the option and enter the name of the Shared-Memory to use shared-memory protocol to connect to a MySQL server, if the server permits shared-memory connections.
    10. Named PIPE Protocol: Check the option and enter the name of the Named PIPE to use named pipes protocol to connect to a MySQL server, if the server permits named-pipe connections.
    11. Socket Protocol: Check the option and select a socket file to use socket protocol to connect to a MySQL server, if the server permits socket connections.
After setting up all of the General options, you can click Test Connection button to test if the connection is successful or not.



See also:
  1. Task - Back up MySQL databases to the SQL files
  2. Task - Back up MySQL databases to the other server
  3. Task - Back up a MySQL database to the other database
  4. Task - Restore MySQL databases from the backup files
  5. Task - Restore MySQL databases from the other server
  6. Task - Restore a MySQL database from the other database
  7. Task - Execute SQL Script
  8. Page - Source Server and Database
  9. Page - Destination Server and Database
  10. Page - Select Databases
  11. Page - Select Source Items
  12. Page - Add Backup Files
  13. Page - Recovery Databases
  14. Page - Backup Files
  15. Page - Upload Backup Files
  16. Page - Execute SQL script before starting and after ending
  17. Page - Enter SQL Script
  18. Page - Task Scheduler
  19. Options - MySQL Database Advanced Settings
  20. Options - Backup File Settings
  21. Options - Compression Options
  22. Options - Back up Tablespaces
  23. Options - SMTP Options
  24. Protocol - SSL Protocol
  25. Protocol - SSH Tunneling
Copyright © 2024 Database Think Software. All rights reserved.