MySQL Database Restore Error

  • Hi there.

    I’m moving hosts and I tried restoring my database using phpMyAdmin. But I keep getting an error:

    #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 ‘collate latin1_general_ci NOT NULL default ”,
    text text co

    I’m a total noob in MySQL and databases and such, so that error is all Greek to me. Please, would anybody know how to fix it?

    Thank you in advance,
    Qis

Viewing 4 replies - 1 through 4 (of 4 total)

  • https://www.ads-software.com/support/topic/66129?replies=6
    Might look at this.

    Thread Starter milque

    (@milque)

    That didn’t work. The error that I get and the one from the link you posted is kinda different…

    Thank you, though

    text text co

    Where is this coming from? An rss feed perhaps? Seems to be the problem.

    Thread Starter milque

    (@milque)

    This is the code:


    CREATE TABLE     wp_calendar (
    timestamp int( 11 ) NOT NULL default ‘0’,
    type varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ”,
    text text COLLATE latin1_general_ci NOT NULL ,
    PRIMARY KEY ( timestamp ) ,
    UNIQUE KEY timestamp ( timestamp )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci COMMENT = ‘wordpress Calendar plugin by Vanguard’;

    And I have no idea where text text co came from.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘MySQL Database Restore Error’ is closed to new replies.

Tags