Plesk Migration ERROR: “Incorrect table definition there can be only one auto column and it must be defined as a key”
While migrating to a new version of Plesk from using MySQL engine MyISAM to MySQL engine InnoDB when trying to import database backup to new database the following error message appears:
"ERROR Incorrect table definition; there can be only one auto column and it must be defined as a key"
The workaround is to manually add "primary key" after every auto_increment entry on the backup file before restoration. Also, remove on the ALTER table section or the ADD primary keys and remove any empty ALTER tables from the backup file.