MySQL database import error # 1064

I have a SQL database that I want to import using phplyadmin, but I am getting this error.

CREATE TABLE  `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,
PRIMARY KEY (  `meta_id` ) ,
KEY  `comment_id` (  `comment_id` ) ,
KEY  `meta_key` (  `meta_key` ( 191 ) )
) ENGINE = Aria AUTO_INCREMENT =3843 DEFAULT CHARSET = utf8          
PAGE_CHECKSUM =1 DELAY_KEY_WRITE =1 TRANSACTIONAL =1;

      

MySQL said: Documentation

# 1064 - You have an error in your SQL syntax; check the manual corresponding to the MySQL server version for the correct syntax to use next to 'PAGE_CHECKSUM = 1 DELAY_KEY_WRITE = 1 TRANSACTIONAL = 1' on line 9

+3


source to share


1 answer


If you are not using MariaDB , change ENGINE=Aria

to ENGINE=MyISAM

(or ENGINE=InnoDB

) and remove PAGE_CHECKSUM=1

and TRANSACTIONAL =1

;



Find an example here

+5


source







All Articles