Database Fails to Upgrade

[Skip1313]

Migrating servers while upgrading from 0.8.8 to 1.2.9.
MySQL server both at v5.7.
After restoring MySQL dump and restarting cacti, Installation Wizard fails at Database upgrade with following error:

RENAME TABLE `plugin_discover_hosts` TO `automation_devices` [Skipped]
ALTER TABLE `automation_devices` DROP `hash` [Skipped]
ALTER TABLE automation_devices ADD COLUMN id BIGINT unsigned auto_increment FIRST, ADD COLUMN network_id INT unsigned NOT NULL default '0' AFTER id, ADD COLUMN snmp_port int(10) unsigned NOT NULL DEFAULT '161' AFTER snmp_version, ADD COLUMN snmp_engine_id varchar(30) DEFAULT '' AFTER snmp_context, DROP PRIMARY KEY, ADD PRIMARY KEY(id), ADD UNIQUE INDEX ip(ip); ADD INDEX network_id(network_id), COMMENT='Table of Discovered Devices' [Fail]

[TheWitness]

Did it fail because the columns were already there? What is the tables current struction:

SHOW CREATE TABLE automation_devices;

[Skip1313]

Please see attachment

[Skip1313]

You were right. Table was already there. I was not dropping the cacti DB before restoring the dump.

[lumejia]

sorry, but I did not understand how this problem was solved, could you explain