Skip to content

Analytics

Matomo Analytics is installed on the Hostinger server at https://i.shepherdsglobal.org.

Installation

To install Matomo, create a new empty site in Hostinger, then use wget to download the latest matomo zip file and unzip it, then follow the install instructions after pointing a subdomain on Cloudflare to the new Hostinger site where you just unzipped the files. You will have to create a new MySQL database in Hostinger and then input the DB credentials in the Matomo setup page.

Then import the old SQL database:

mysql -u u159938358_sgc_stats -p u159938358_sgc_matomo < matomo-2024-12-26.sql

This will overwrite whatever is currently in the database. Afterwards, log in using the same credentials you used to use (the imported DB has your previous credentials already in it).

Set up a cron job to archive visits every 30 min to help speed up the dashboard:

0,30 * * * * /usr/bin/php /home/u159938358/domains/i.shepherdsglobal.org/public_html/console core:archive

In order to keep data flowing via the Cloudflare worker, it was necessary to generate a new token_auth for the cfworker user and update the CF worker with the new auth code.

Backups

Set up daily DB backups. First, install the "Data Export" plugin, then activate it and set the settings to "Run automatic database dumps" daily.