Recover email forwarding list after failed upgrade to centos8

Make a backup of the dbispconfig database, you can do that with the mysqldump command. Example:

mysqldump -u root -p dbispconfig > dbispconfig.sql

The command will then ask for mysql root password.

Then you should make a backup of the folder /etc, /var/vmail, /usr/local/ispconfig and /var/www. Take care to preserve permissions e.g. by using commands like "tar pcfz vmail.tar.gz /var/vmail" to back up the folders. Just to be sure, but the most important part in your case is the dbispconfig database as you seem to use mail and DNS only.

We will then have to see how the reimport can be done as you switch to another OS, so we can't import the full dbispconfig database without damaging the new system configuration. Most likely, you have to import the database dump into a temporary database, then export separately only the mail_*, spamfilter_* and dns_* tables using phpmyadmin and then import these into the new ISPConfig datababase and then use Tools > resync in ISPConfig to write the config to disk.

 

The procedure is this:

We will then have to see how the reimport can be done as you switch to another OS, so we can't import the full dbispconfig database without damaging the new system configuration. Most likely, you have to import the database dump into a temporary database, then export separately only the mail_*, spamfilter_* and dns_* tables using phpmyadmin and then import these into the new ISPConfig datababase and then use Tools > resync in ISPConfig to write the config to disk.

 

You can re-add the data using phpmyadmin, this is the easiest way and works well. Of course you may add data manually using the API, but this is way more complicated and requires you to write a program for the SOAP or REST API.

Maybe you should contact business support and ask for a quote that Thom imports the data for you:

https://www.ispconfig.org/get-support/?type=ispconfig