Matomo database will be upgraded from version 4.1.1 to the new version 4.2.0.
Important notes for large Matomo installations
If you have a large Matomo database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
# These console commands will be run: php /var/www/html/console core:invalidate-report-data --sites=all --dates=2020-11-23,2021-03-06 --plugin=VisitFrequency
# These SQL queries will be executed: UPDATE `matomo_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.';
