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:
php /var/www/html/console core:update
If you manage a high traffic Matomo server, we recommend to momentarily disable visitor Tracking and put the Matomo User Interface in maintenance mode.
FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 4.2.0
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These console commands will be run:
# These SQL queries will be executed:
UPDATE `matomo_archive_numeric_2014_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_01` 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.';
Need help upgrading Matomo?
If you need support to upgrade your Matomo, the creators of Matomo are here to help you make the Matomo upgrade a success and provide all instructions, best practises and ongoing support. Contact the Matomo experts to get started upgrading your Matomo safely.
Ready to go?
The database upgrade process may take a while, so please be patient.
