Error restoring SQL database

  • Resolved ronsrace

    (@ronsrace)


    18 years, 4 months ago

    Hi,

    Restoring my SQL database gives me the following error:

    Fout

    SQL-query :

    CREATE TABLE wp_alinks_keyphrases (
    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    keyphrase varchar( 250 ) NOT NULL default ”,
    description varchar( 250 ) NOT NULL default ”,
    defines text NOT NULL ,
    module varchar( 60 ) NOT NULL default ”,
    created timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    hash varchar( 32 ) NOT NULL default ”,
    PRIMARY KEY ( id ) ,
    KEY keyword_keyword ( keyphrase )
    )ENGINE = MYISAM DEFAULT CHARSET = latin1

    MySQL retourneerde:
    #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 ‘CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    hash varchar

    Any suggestions how I can get my backup restored??

    thx

    Ron

  • The topic ‘Error restoring SQL database’ is closed to new replies.

Tags