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 Name
• DB User
• DB Pass
• 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"
• MySQL Config File
• MySQL Curl Callback

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
• Toggle website into maintenance (only if curl callback is configured)

Rules:

• If export fail, then table will be skipped

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
• Toggle website into maintenance (only if curl callback is configured)
• Destination label
• Try call SET GLOBAL `max_allowed_packet` = '?'; (Y/N)

Rules:

• Every tables compared by name will be overwritten on destination by source.
• If export fail, then table will be skipped

Config:

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

Open backup folder

This tool is used for open backup folder.

Data entered:

• Label

MySQL Console

This tool is used for connect directly to database then use SQL queries.

Data entered:

• Label
• MySQL: query or internal command (@exit / @close / @open)

Config:

• AVE_DATA_FOLDER - output data folder

Backup selected tables

This tool is used for make backup for selected tabled.

Data entered:

• Label
• Toggle website into maintenance (only if curl callback is configured)
• Tables (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

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