• Following a mistake made by one of our workers, our entire DB was deleted, but we do backup weekly.
    Unfortunately I seem to be having some problems with the whole restore process.
    I have my .sql file and can open it and read it, but I can’t get the db to be recognised by the server.

    The output I get is:
    SQL-query:


    — Table structure for table cinj_news_cats

    CREATE TABLE cinj_news_cats(
    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    category text NOT NULL ,
    defaultint( 1 ) NOT NULL default ‘0’,
    PRIMARY KEY ( id )
    ) TYPE = MYISAM

    MySQL said:
    #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 ‘default int(1) NOT NULL default ‘0’,
    PRIMARY KEY (id)
    ) TYPE

    Any clue here would be really appreciated.
    Is there a simple process I could follow to get the whole thing back? We really miss it.

  • The topic ‘MySql import problems’ is closed to new replies.