Importing WordPress Database - #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

For each Wordpress table, add its key in this way (see the penultimate line):

CREATE TABLE IF NOT EXISTS `wp_commentmeta` (  `meta_id` bigint(20) unsigned NOT NULL auto_increment,  `comment_id` bigint(20) unsigned NOT NULL default '0',  `meta_key` varchar(255) default NULL,  `meta_value` longtext,  key (meta_id) -- add this line (remember to add the comma in the previous line)) ENGINE=MyISAM AUTO_INCREMENT=236 DEFAULT CHARSET=utf8;

Wordpress tables:

wp_commentmetawp_commentswp_linkswp_optionswp_postmetawp_postswp_termswp_term_relationshipswp_term_taxonomywp_usermetawp_users

Possible that you are using two different versions of phpmyadmin, one in plesk, the other one in your cpanel system?

You could try 'Adminer', which is a powerful phpmyadmin alternative and it is based on only one single file!

Download it from here: http://www.adminer.org/en/

Copy adminer.php to the server where you want to get the export from and to the one where you want to import the sql data.

Go to your website/adminer.php and login to your db with the credentials you have. The Export and import is similar to phpmyadmin but the advantage is that you are using one common version of the adminer software which makes sure that import and export is gonna be run fine.

I have the same problem when I export from another phpMyAdmin, the file mysql export does not include primary key in there, then when exporting I choosed method "Custom - display all possible options", then I checked "IF NOT EXISTS (less efficient as indexes will be generated during table creation)". And then the exported file included primary key in the file. And my problem is solved. I hope this help you.