How can I move Piwik from one server to another, also migrating the data from one mysql server to another?
If you want to keep the data in your Piwik, but move the php files to another server and the data to another mysql server, you will need to: • Export your mysql database in a file; you can use tools such as phpmyadmin to do this. Note that you do not need to backup the piwik_archive_* tables, as they would be automatically re-created and processed from the other piwik tables. • Import the backed up database in your new server; you can use phpmyadmin to import the file that you previously created. This should create more than a dozen Piwik tables in your database. • Install Piwik in your new server; during the installation process, you will be asked to provide the mysql server, login, password and table prefix. It is very important that you specify the same table prefix (by default, “piwik_”). Piwik will detect that the tables are present in the database and all your existing websites and reports will be automatically detected. • If the Piwik domain name has changed, you also need to ch