DB upgrade from 1.8.8 to 2.0.6 fails

[tiainpa]

Hi,

I'm trying to upgrade our Zabbix 1.8.8 to 2.0.6 but somehow the DB upgrade script fails every time.

I'm wondering something has happened to our DB, as it seems it is missing quite many needed tables like users etc.

Example output:

./upgrade -uroot -pxxxxxx -Dzabbix
 WARNING: backup your database before performing upgrade

 This is an UNSUPPORTED Zabbix upgrade script from 1.8 to 2.0 for MySQL
 It does the following things:
  1. Updates indexes that might require changes;
  2. Patches the database from 1.8 schema to 2.0 schema;
  3. Adds 'Disabled' and 'Debug' usergroup if any missing;
  4. Checks for hosts not belonging to any group and adds them to one if any found.

 Usage: pass required MySQL parameters to this script (like database, user, password etc).

Continue ? (y/n) y
Patching the database
ERROR 1146 (42S02) at line 4: Table 'zabbix.users' doesn't exist
Failed to patch Zabbix database. Restore from backup

Any ideas how to continue? I know that the schema.sql does try to create the necessary tables but I didn't know it was needed to be imported before the patch.sql.

Thank you in advance!

Best Regards,
-Pasi

[tiainpa]

Issue solved

I got rid of this problem by restoring a DB backup created by AutoMySQLBackup.

The previous attempt was done using phpMyAdmin's DB export, so maybe the export operation failed thus leaving out quite a lot of the tables needed by Zabbix.

Cheers,
-Pasi