upgrade_db_zonemaster_backend_ver_5.0.0.md

If your zonemaster database was created by a Zonemaster-Backend version smaller than v5.0.0, and not upgraded, use the instructions in this file.

FreeBSD

If the installation is on FreeBSD, then set the environment before running any of the commands below:

export ZONEMASTER_BACKEND_CONFIG_FILE="/usr/local/etc/zonemaster/backend_config.ini"

MySQL (or MariaDB)

Run

cd $(perl -MFile::ShareDir -le 'print File::ShareDir::dist_dir("Zonemaster-Backend")')
perl patch_mysql_db_zonemaster_backend_ver_5.0.0.pl

PostgreSQL

Run

cd $(perl -MFile::ShareDir -le 'print File::ShareDir::dist_dir("Zonemaster-Backend")')
perl patch_postgresql_db_zonemaster_backend_ver_5.0.0.pl