Download Latest Version
MySQL _ MariaDB Portable source code.tar.gz (5.8 MB)
Get an email when there's a new version of apache-logs-to-mysql
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| Raw _ Refined schema script source code.tar.gz | 2025-02-15 | 5.6 MB | |
| Raw _ Refined schema script source code.zip | 2025-02-15 | 5.6 MB | |
| README.md | 2025-02-15 | 1.6 kB | |
| Refined schema script for MySQL _ MariaDB source code.tar.gz | 2025-02-15 | 5.6 MB | |
| Refined schema script for MySQL _ MariaDB source code.zip | 2025-02-15 | 5.6 MB | |
| Totals: 5 Items | 22.3 MB | 0 | |
The first I heard about this problem was by email at 4PM today. Clearly no one else has attempted to install on MariaDB or fixed the issue themselves. This is a much better approach since I now have a python script to consolidate the 25 source code scripts into a much smaller SQL file without any of the TABLE LOCKS and SET environment variables. The file is now just raw, bare bones script. Please email or create issue for any problems. I am working on the Web interface for this and will have initial release first week of March.
- [3.2.6] created new Python script to generate
apache_logs_schema.sqlfrom the 25 refined development source code scripts. Prior to this version file was generated by MySQL Workbench. - [3.2.6] repository had MySQL Workbench generated script that added CHARSET and COLLATE. The raw source code scripts did not specify CHARSET or COLLATE. Raw source code scripts worked fine on MySQL and MariaDB testing.
- [3.2.6] MySQL 9.1 default is CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci. MariaDB 11.6 default is CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci. COLLATE=utf8mb4_0900_ai_ci does not exist in MariaDB causing script errors.
- [3.2.6] The solution that works for both MySQL and MariaDB is only specify CHARSET=utf8mb4. If CHARACTER SET charset_name is specified without COLLATE, character set charset_name and its default collation are used.