WordPress.org

1. frhong
   Member
   Posted 3 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. podz
   Support Maven
   Posted 3 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 3 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. podz
   Support Maven
   Posted 3 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.