MySQLTools

Configure connection

This tool is used for configure MySQL connection.

Data entered:

• Label: A short phrase identifying the connection in other sub tools
• Output: Destination folder where save backup (label will be added automatically)
• DB Host
• DB Port
• DB Name (Type * for none)
• DB User
• DB Pass
• Backup structure (Y/N)
• Backup data (Y/N)
• Compress after backup (Y/N)
• Lock tables during background backup (Y/N)

Config:

• Every mysql connection config is stored into "%LOCALAPPDATA%\NGC-TOOLKIT\MySQL\{label}.ini"

• MySQL Tools Config File
• MySQL Tools Curl Callback

Remove connection

This tool is used for remove connection config.

Data entered:

• Label / ID

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 full database backup.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Lock tables during backup (Y/N)

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• 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 / ID
• Toggle website into maintenance (only if curl callback is configured)
• Lock tables during clone (Y/N)
• Destination label / ID

Rules:

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

Open backup folder

This tool is used for open backup folder.

Data entered:

• Label / ID

MySQL Console

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

Data entered:

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

Config:

• DATA_FOLDER - output data folder

Backup selected tables structure

This tool is used for make backup for selected tables structure.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Backup selected tables data

This tool is used for make backup for selected tables data.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Lock tables during backup (Y/N)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Backup selected views

This tool is used for make backup for selected views.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Backup selected functions

This tool is used for make backup for selected functions.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Backup selected procedures

This tool is used for make backup for selected procedures.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Backup selected events

This tool is used for make backup for selected events.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Backup selected triggers

This tool is used for make backup for selected triggers.

Data entered:

• Label / ID
• Toggle website into maintenance (only if curl callback is configured)
• Compress backup (Y/N)
• Names (One or multiple separated by space, escaped by double quotes ")

Rules:

• If export fail, then table will be skipped

Config:

• BACKUP_COMPRESS_LEVEL - backup compress level
• BACKUP_COMPRESS_TYPE - backup compress type

Fetch data base info

This tool is used for export data base info into csv file.

Informations exported:

• Table
• Engine
• Collation
• Rows
• Data size
• Data size (Bytes)
• Index size
• Index size (Bytes)
• Row format

Data entered:

• Label / ID

Rules:

• Analyze table before fetch informations

Compare data base info

Informations compared:

• Table
• Engine
• Collation
• Rows
• Data size
• Index size
• Row format

Data entered:

• Source label / ID
• Destination label / ID

Rules:

• Analyze table before fetch informations