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.