MySql4.0.x与Mysql4.1.x及以上版本相互转换

April 21, 2007 at 20:52 · Filed under 机械境

　　这几天在用MySQL4.0.26的数据库时想到以后我要升级数据库了或者搬换空间了怎么办?所以在MySQL4.0.26数据库的环境装了个Wordpress,然后参考21Andy的MySql4.0与Mysql4.1及以上版本相互转换,然后到处数据库,修改后导入到Dreamhost空间的MySQL5.0.24a-standard上,运行正常.不过最好先执行字符集校正为:UTF-8 general,然后在phpMyAdmind的SQL命令窗口输入
SET NAMES ‘utf8′;
SET CHARACTER SET ‘utf8′;
SET CHARACTER_SET_CLIENT = ‘utf8′;
SET COLLATION_CONNECTION=’utf8_general_ci’;
SET CHARACTER_SET_RESULTS = ‘utf8′;
SET CHARACTER_SET_SERVER = ‘utf8′;
保险一点嘛,如果浏览Wordpress还出现乱码,则在wp-includes/wp-db.php的文件里

Comments | Permalink 转载原创文章请注明,^o^..