Migrate a matomo Site to another Server

General questions
1

Hi,
am trying to migrate a site from one Matomo instance to another (both servers have multiple sites)
using the matomo migration plugin as described.

i used this command:
sudo -u www-data ./console migration:measurable --source-idsite=105 --target-db-host=1.2.3.4 --target-db-username=raven --target-db-password=strongpass --target-db-name=raven --dry-run

returns an error:

ERROR [2024-05-02 20:21:02] 1286542 SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘raven.site’ doesn’t exist [Query: , CLI mode: 1]

[Zend_Db_Statement_Exception]
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘raven.site’ doesn’t exist

i would be thankful for any tips
BR

2

Hi! I just tried the same and got the same error. Seems that the configured tables_prefix isn’t respected for the migration plugin … could that be?

EDIT: I added the --target-db-prefix=<your prefix> to the command and it works now.

3

Hi Raven! It looks like the migration command can’t find the site table in the target database. Make sure that the database structure on the target server is set up correctly before running the migration. You might also want to check if the Matomo instance on the target server has been initialized properly. If the issue persists, reviewing the migration logs for more details could help. Good luck!