WordPress.org

Ready to get started?Download WordPress

Forums

Cannot restore in a higher Mysql? (4 posts)

  1. frhong
    Member
    Posted 8 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 )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1
    --------------------------------------------------

    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 8 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
    Member
    Posted 8 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 8 years ago #

    notepad++ can set character sets
    http://notepad-plus.sourceforge.net/uk/about.php

    For huge files, use jujuedit
    http://www.jujusoft.com/software/edit/

Topic Closed

This topic has been closed to new replies.

About this Topic