-
Notifications
You must be signed in to change notification settings - Fork 0
MySQLToolsConfigFile
AbyssMorgan edited this page Jun 28, 2025
·
7 revisions
For locate configuration file, run NGC-TOOLKIT and select tool 6 2, then edit <label>.ini
| Key | Type | Default | Available values | Description |
|---|---|---|---|---|
| DB_HOST | String | - | - | Database host name |
| DB_PORT | Integer | - | - | Database port |
| DB_NAME | String | - | - | Database name |
| DB_USER | String | - | - | Database user |
| DB_PASSWORD | String | - | - | Database password |
| BACKUP_PATH | String | - | Valid folder path | Backup location |
| BACKUP_COMPRESS | Bool | - | true / false | Determine if compress backup |
| BACKUP_TYPE_DATA | Bool | - | true / false | Determine if backup data from table |
| BACKUP_TYPE_STRUCTURE | Bool | - | true / false | Determine if backup structure from table |
| BACKUP_ADD_LABEL_TO_PATH | Bool | true | true / false | Determine if label should be added to path |
| BACKUP_CURL_SEND_ERRORS | Bool | false | true / false | Determine if curl callback can sent errors |
| BACKUP_CURL_CALLBACK | String / Null | null | - | Specify www url than be called when perform backup more information |
| BACKUP_CURL_HTTP_VERSION | Int | 2 | Curl Http Version | Determine http version for requests |
| BACKUP_QUERY_LIMIT | Integer | 50000 | - | Determine how many records should be select at once |
| BACKUP_INSERT_LIMIT | Integer | 100 | - | Determine how many records should be added in a single insert |
| SAVE_RESULTS_SEPARATOR | String | | | - | Determine separator for columns when use MySQL Console |
| FOLDER_DATE_FORMAT | String | Y-m-d_His | - | Determine backup folder date format |
| BACKUP_LOCK_TABLES | Bool | false | true / false | Determine if lock tabled during backup |
- F1 - File Functions
- F2 - File Sorter
- 0 - Sort by date
- 1 - Sort by extension
- 2 - Sort by size
- 3 - Sort by name prefix
- 4 - Sort by mime type
- F3 - File Names Editor
- 0 - Generate names: CheckSum
- 1 - Generate names: Number (Video/Images)
- 2 - Generate video: CheckSum/Orientation/Thumbnail
- 3 - Generate series name: S00E00 etc.
- 4 - Escape file name (WWW)
- 5 - Pretty file name
- 6 - Remove YouTube quality tag
- 7 - Series episode editor
- 8 - Add file name prefix/suffix
- 9 - Remove keywords from file name
- 10 - Insert string into file name
- 11 - Replace keywords in file name
- 12 - Extension change
- F4 - File Editor
- D1 - Directory Functions
- D2 - Directory Sorter
- D3 - Directory Names Editor
- M1 - Media Tools
- 0 - Merge: Video + Audio
- 1 - Merge: Video + SRT
- 2 - Avatar generator
- 3 - Fetch media info (Video)
- 4 - Image converter
- 5 - Ident mime type
- 6 - Extract video
- 7 - Extract audio
- 8 - Extract subtitles
- 9 - Validate subtitles (SRT)
- 10 - Compare subtitles (SRT)
- M2 - Media Sorter
- T1 - MySQL Tools
- 0 - Configure connection
- 1 - Remove connection
- 2 - Open config folder
- 3 - Show connections
- 4 - Make backup
- 5 - Clone DB1 to DB2 (overwrite)
- 6 - Open backup folder
- 7 - MySQL Console
- 8 - Backup selected: Tables structure
- 9 - Backup selected: Tables data
- 10 - Backup selected: Views
- 11 - Backup selected: Functions
- 12 - Backup selected: Procedures
- 13 - Backup selected: Events
- 14 - Backup selected: Triggers
- 15 - Fetch data base info
- 16 - Compare data base info
- T2 - FTP Tools
- 0 - Configure connection
- 1 - Remove connection
- 2 - Open config folder
- 3 - Show connections
- 4 - Get file list
- 5 - Download files
- 6 - Upload files
- 7 - Delete files
- 8 - Delete empty folders
- 9 - Delete structure (folders and files)
- 10 - Copy files from FTP to FTP
- 11 - Import FileZilla XML
- O1 - Check File Integrity
- O2 - ADM File Converter
- H - Help
- 0 - Show documentation
- 1 - Open config folder
- 2 - Open logs folder
- 3 - Open data folder
- 4 - Open program folder
- 5 - Check for updates
- 6 - Restore default settings