Home

MySQL

Move to Drupal: 80% complete!

Posted 2006-03-06 (月) 午後11:41 by terra

An update! after, what, 8 months of procrastination? It’s been so long since I last posted a blog entry that I’ve nearly forgotten how to write. This site has finally been Drupalised — after playing 睨めっこ with my trusty (but bulky) DELL trinitron over the past week, after work and over the weekend. The catalyst for this decision was the wonderful relevation that Drupal 4.7 beta now supports unicode MySQL properly. This means that my Japanese and Chinese words no longer look rubbish in phpmyadmin. How nice is that? Over the next few weeks, you will see more embellishments to this web space, and more importantly, updates (I hope!) to this blog. I can’t wait for Drupal 4.7 to be final which would mean more cool modules. I’m such a sucker for the taxonomies in Drupal. I’ve always been obsessed about cataloging things — as seen from my old Mythology webbie and my Led Zep bootleg collection — which makes Drupal my blogger’s ambrosia. :-P

Subjects: Websites ウェブサイト

Mood: Declarations

Tags: database, Drupal, MySQL, unicode, website

Remote server SQL export/import woes *Fixed*

Posted 2005-07-03 (日) 午後11:42 by terra

The following is only for my future reference and should not realy interest anyone else unless that person is facing a similar problem as I did.

Goal:

To import multilingual data from remote hosting to production server on PC, ensuring that nothing is corrupted in the process.

Problem definition:

MySQL database located on webhost (Server 1) did not import correctly multilingual text correctly. Webhost’s character set was set to latin1 whereas production server on PC (Server 2) was set to UTF-8. One is able to check the settings of the servers by typing show variables in mysql shell.

Subjects: Technology 技術

Tags: database, MySQL, unicode

Unicode Nightmare

Posted 2005-05-16 (月) 午前3:13 by terra

Migrating from MySQL4.0 to 4.1 is a complete nightmare for one whose webserver is remotely located and whose account is equipped with insufficient administrative rights. I’ve learnt quite a lot in the past two days, but suffered a great deal of grief throughout the journey.

“Was it all worth it?”, is something that I’ve been asking myself the day I began web designing…

疲れ切った私…

Subjects: Technology 技術, Websites ウェブサイト

Mood: Raves and Rants

Tags: database, MySQL, website

Syndicate content