-- ============================================================
--  How to permanently raise MySQL's max_allowed_packet on XAMPP
-- ============================================================
--
--  XAMPP defaults max_allowed_packet to ~1 MB, which is too small for
--  storing big aggregated JSON outputs in `generated_outputs`.
--
--  This file is documentation, not a runnable SQL script — the setting
--  must be changed in MySQL's config file, then MySQL restarted.
--
--  STEPS (Windows / XAMPP):
--
--  1. Open in any text editor (run as Administrator):
--         C:\xampp\mysql\bin\my.ini
--
--  2. Under the [mysqld] section, add (or change) this line:
--
--         max_allowed_packet = 64M
--
--     A complete [mysqld] block looks like:
--
--         [mysqld]
--         max_allowed_packet = 64M
--         (other XAMPP-default settings...)
--
--  3. Save the file.
--
--  4. Open the XAMPP Control Panel:
--         next to MySQL, click Stop, wait 2 seconds, click Start.
--
--  5. Confirm the change took effect (run in phpMyAdmin SQL tab):
--
--         SHOW VARIABLES LIKE 'max_allowed_packet';
--
--     Expected value:  67108864   (i.e. 64 MB).
--
--  TEMPORARY (until MySQL restarts):
--    SET GLOBAL max_allowed_packet = 67108864;
--    -- (requires SUPER privilege; XAMPP root has it.)
--
-- ============================================================
