Cannot restore in a higher Mysql? (4 posts)

  1. frhong
    Posted 10 years ago #

    Hi, I backup my WP in a MySQL 4.1.14 and try to restore datas in a MySQL 4.0.21, but it pops up a message as:

    # Table structure of table en_categories
    CREATE TABLE en_categories (
    cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) NOT NULL default '',
    category_nicename varchar( 200 ) NOT NULL default '',
    category_description longtext NOT NULL ,
    category_parent int( 4 ) NOT NULL default '0',
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )

    I've posted this in other WP forums and seems not just me got this, many other people had got this problem before. I 've also searched the net and this site but can't find the answers.

    Does anyone know how to cope with this?

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Open the .sql file in a plaintext editor

    Do a search/replace with
    DEFAULT CHARSET = latin1
    being replaced with nothing at all

    Things should be good then :)

  3. frhong
    Posted 10 years ago #

    Hey, it seems working! Thanks:)

    But what's the problem of this? Is it going to cause any further problems?

    PS. I try notepad as the plaintext editor, but since I got some Chinese and Japanese charactors in it, the encoding just totally mixed up! Could u recommond a good, and more important FREE, editor?

  4. Mark (podz)
    Support Maven
    Posted 10 years ago #

    notepad++ can set character sets

    For huge files, use jujuedit

Topic Closed

This topic has been closed to new replies.

About this Topic