好吧，终于搞定新空间了 +

感谢zsp007师兄的VPS空间，和他的帮助 :)

第一次折腾gentoo的portage，对layman非常不熟悉导致php-fpm没装成功，偷懒装了spawn-fcgi+nginx。。。。。

wordpress 3.0很囧。。。装个插件都要FTP支持。所以还是继续2.x版本好了。况且我也修改了那么多wordpress内核文件，也懒得重新修改一次了。

然后就是让我异常头大的MySQL乱码问题。我才发现，Dreamhost空间的MySQL配置是有点异样的。主要是character_set_server设置成了latin1，然后就是一大陀杯具。比如说汉字的 看 的UTF8编码本来应该是\xe7\x9c\x8b，但是从SELECT HEX(columnname) FROM table的结果来看，居然是 C3A7C593E280B9。两重编码。然后鼓捣鼓捣了2个晚上才把dump文件搞定，然后才没有乱码导入

觉得最爽的工具组合是ssh TCP端口转发到本地，然后用Navicat 8来直接操作MySQL。省去了再去调节PuTTY终端编码这又一层复杂度。

就是这样。

This entry was posted on Sunday, July 18th, 2010 at 13:32 and is filed under Tech. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

12 Responses to “好吧，终于搞定新空间了”

  1. Postman | July 18th, 2010 at 16:02 +

    终于回归了。。。

  2. A.shun | July 18th, 2010 at 16:40 +

    恭喜了，新的主机速度不错。

    wp3.0还观望中呢

  3. coolxll | July 18th, 2010 at 20:08 +

    占座围观，欢迎回归

  4. aXqd | July 18th, 2010 at 23:56 +

    Sheldon: “My new computer came with Windows 7. Windows 7 is much more user friendly than Windows Vista.....I don’t like that.”

  5. unrealTournament | July 18th, 2010 at 23:56 +

    离开了这么久才回来，快上点儿福利，以飨读者

  6. 深蓝 | July 18th, 2010 at 23:56 +

    终于回来了。热烈欢迎

  7. unrealTournament | July 18th, 2010 at 23:57 +

    好吧～杂草 好吧～石头～～

  8. Yibie | July 19th, 2010 at 00:02 +

    珠海人民发来贺电

  9. rocky | July 19th, 2010 at 12:12 +

    恭喜恭喜！

  10. kids | July 19th, 2010 at 20:16 +

    天天盼，日日盼，总算盼到头了

  11. shellex | July 29th, 2010 at 14:49 +

    没有你的日子挺难过...而且换了feedburner的RSS烧录真好

  12. Black-Xstar | August 4th, 2010 at 01:17 +

    呃，才发现是T2的机器。

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
MARKDOWN is also enabled.