[How to] Tables were not upgraded with Panel upgrade. How to upgrade them manually?

Created:

2016-11-16 13:01:30 UTC

Modified:

2017-04-24 12:00:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[How to] Tables were not upgraded with Panel upgrade. How to upgrade them manually?

Applicable to:

  • Plesk 9.x and below for Windows

Symptoms

After upgrading of Parallels Panel to version 8.6 several tables in the database were not upgraded, for example table psa.siteapps. The tables have old structure and this causes errors.I cannot upgrade the tables with with Plesk_8.2_to_8.6_DatabaseUpgrade.exe . Simply changing database structure is not a solution. Upgrade of table Siteapps is more complex procedure than this.

How to upgrade the tables?

Resolution

As solution it is recommended that you use utility dbupgrade.exe from Plesk 9.x that is attached .

  1. Copy file dbupgrade.exe from PP 9.2.3 into %plesk_bin% folder on target Plesk 8.6.0 server
  2. Copy files psadb_*.xml there either
  3. Run command
    dbupgrade.exe --upgrade --from-version=8.2.0 --to-version=8.6.0

Its strongly recommended to backup Plesk database before do this.

Have more questions? Submit a request
Please sign in to leave a comment.