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.

Was this article helpful?
1 out of 2 found this helpful

Have more questions? Contact our support instantly via Live Chat