SQL Error #1064 when importing database backed up in MAMP

I’m getting this error when importing a database to create a live live. The site was created as a localhost using MAMP. I have followed the MySQL compatibility recommendations in this post without success. Various iterations always come back to this same error.

Error
SQL query:

—
— Database: WordPressp
—
— ——————————————————–
—
— Table structure for table wp_pcommentmeta
—
CREATE TABLE wp_pcommentmeta (

meta_id BIGINT( 20 ) UNSIGNED NOT NULL ,
comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT ‘0’,
meta_key VARCHAR( 255 ) DEFAULT NULL ,
meta_value LONGTEXT
) TYPE = INNODB;

MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=InnoDB’ at line 16
————————–

Help please!

Cheers, S