Support » Fixing WordPress » Errors when importing database

  • Resolved kyarauk

    (@kyarauk)


    I have decided to move my site from 000webhost to hostinger, I exported my database from 000webhost and I am trying to import it to hostinger, but I get the following error

    Error
    SQL query:

    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 ) )
    ) TYPE = MYISAM AUTO_INCREMENT =3;

    MySQL said: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘TYPE=MyISAM AUTO_INCREMENT=3’ at line 9

    Can someone please help?

Viewing 1 replies (of 1 total)
  • Thread Starter kyarauk

    (@kyarauk)

    Okay – I’ve fixed it. It turns out TYPE is deprecated and instead it should be replaced with ENGINE.

Viewing 1 replies (of 1 total)
  • The topic ‘Errors when importing database’ is closed to new replies.