MySQLTools

Configure connection

This tool is used for configure MySQL connection.

Data entered:

• Label: A short phrase identifying the database in subsequent steps
• Output: Destination folder where save backup (label will be added automatically)
• DB Host
• DB Port
• DB User
• DB Pass
• DB Name
• Backup structure (Y/N)
• Backup data (Y/N)
• Compress after backup (Y/N)

Config:

• Every mysql connection config is stored into "%LOCALAPPDATA%/AVE/MySQL/{label}.ini"

Remove connection

This tool is used for remove connection config.

Data entered:

• Label

Open config folder

This tool is used for open config folder.

Show connections

This tool is used for show connection list.

Make backup

This tool is used for make backup.

Data entered:

• Label

Config:

• AVE_BACKUP_COMPRESS_LEVEL - backup compress level
• AVE_BACKUP_COMPRESS_TYPE - backup compress type

Clone DB1 to DB2 (overwrite)

This tool is used for clone database 1 into database 2.

Data entered:

• Source label
• Destination label
• Try call SET GLOBAL `max_allowed_packet` = '?'; (Y/N)

Rules:

• Every tables compared by name will be overwritten on destination by source.

Config:

• AVE_BACKUP_MAX_ALLOWED_PACKET - value for SET GLOBAL `max_allowed_packet` = ?;