Skip to main content

Migration

Script to import a site with id <SIDE-ID> using the flag --dry-run, remove the flag to run the actual import. The import is run from the original Matomo installation and username, password, prefix etc is for the destination.

  • <DB-PREFIX> is usually matomo_
sudo -uweb -H ./console migration:measurable \
    --source-idsite=<SITE-ID> \
    --target-db-host=127.0.0.1 \
    --target-db-username=<DB-USERNAME> \
    --target-db-password=<DB-PASSWORD> \
    --target-db-name=<DB-NAME> \
    --target-db-prefix=<DB-PREFIX> \
    --dry-run

Database​

All database tables in both installations have to match, here is an example command to add 5 custom dimensions

sudo -uweb -H ./console customdimensions:add-custom-dimension --scope=visit --count=5

or directly to the database:

ALTER TABLE matomo_log_link_visit_action  ADD COLUMN custom_dimension_6 VARCHAR(255),  ADD COLUMN custom_dimension_7 VARCHAR(255),  ADD COLUMN custom_dimension_8 VARCHAR(255),  ADD COLUMN custom_dimension_9 VARCHAR(255),  ADD COLUMN custom_dimension_10 VARCHAR(255);

another example:

ALTER TABLE matomo_log_link_visit_action  ADD COLUMN custom_dimension_11 VARCHAR(255),  ADD COLUMN custom_dimension_12 VARCHAR(255),  ADD COLUMN custom_dimension_13 VARCHAR(255),  ADD COLUMN custom_dimension_14 VARCHAR(255),  ADD COLUMN custom_dimension_15 VARCHAR(255);

matomo_log_conversion​

ALTER TABLE matomo_log_conversion  ADD COLUMN custom_dimension_6 VARCHAR(255),  ADD COLUMN custom_dimension_7 VARCHAR(255),  ADD COLUMN custom_dimension_8 VARCHAR(255),  ADD COLUMN custom_dimension_9 VARCHAR(255),  ADD COLUMN custom_dimension_10 VARCHAR(255);
ALTER TABLE matomo_log_conversion  ADD COLUMN custom_dimension_11 VARCHAR(255),  ADD COLUMN custom_dimension_12 VARCHAR(255),  ADD COLUMN custom_dimension_13 VARCHAR(255),  ADD COLUMN custom_dimension_14 VARCHAR(255),  ADD COLUMN custom_dimension_15 VARCHAR(255);
ALTER TABLE matomo_log_conversion  ADD COLUMN custom_dimension_16 VARCHAR(255),  ADD COLUMN custom_dimension_17 VARCHAR(255),  ADD COLUMN custom_dimension_18 VARCHAR(255),  ADD COLUMN custom_dimension_19 VARCHAR(255),  ADD COLUMN custom_dimension_20 VARCHAR(255);
ALTER TABLE matomo_log_conversion  ADD COLUMN campaign_content VARCHAR(255),  ADD COLUMN campaign_group VARCHAR(255),  ADD COLUMN campaign_id VARCHAR(255),  ADD COLUMN campaign_keyword VARCHAR(255),  ADD COLUMN campaign_name VARCHAR(255),  ADD COLUMN campaign_medium VARCHAR(255),  ADD COLUMN campaign_placement VARCHAR(255),  ADD COLUMN campaign_source VARCHAR(255);

matomo_log_visit​

campaign_content, campaign_group, campaign_id, campaign_keyword, campaign_medium, campaign_name, campaign_placement, campaign_source

ALTER TABLE matomo_log_visit
ADD COLUMN campaign_content VARCHAR(255),
ADD COLUMN campaign_group VARCHAR(255),
ADD COLUMN campaign_id VARCHAR(255),
ADD COLUMN campaign_keyword VARCHAR(255),
ADD COLUMN campaign_medium VARCHAR(255),
ADD COLUMN campaign_name VARCHAR(255),
ADD COLUMN campaign_placement VARCHAR(255),
ADD COLUMN campaign_source VARCHAR(255),
ADD COLUMN custom_dimension_6 VARCHAR(255),
ADD COLUMN custom_dimension_7 VARCHAR(255),
ADD COLUMN custom_dimension_8 VARCHAR(255),
ADD COLUMN custom_dimension_9 VARCHAR(255),
ADD COLUMN custom_dimension_10 VARCHAR(255),
ADD COLUMN custom_dimension_11 VARCHAR(255),
ADD COLUMN custom_dimension_12 VARCHAR(255),
ADD COLUMN custom_dimension_13 VARCHAR(255),
ADD COLUMN custom_dimension_14 VARCHAR(255),
ADD COLUMN custom_dimension_15 VARCHAR(255),
ADD COLUMN custom_dimension_16 VARCHAR(255),
ADD COLUMN custom_dimension_17 VARCHAR(255),
ADD COLUMN custom_dimension_18 VARCHAR(255),
ADD COLUMN custom_dimension_19 VARCHAR(255),
ADD COLUMN custom_dimension_20 VARCHAR(255);