Server upgraded
November 29th, 2006 by Lu Pin
Chinese Movie Database has been moved to a new server, which boasts dual Xeon 2.8GHz and 4GB memory. The server need upgrading because the old one could no longer cop with the heavy load. The system and software of the new server is very similar to the old one, so I expected a smooth transfer. Nothing is straight forward however…
First there was an error in php compilation which causes abortion of php scripts. Then I underestimated the complexity of MySQL 4.0 to 4.1 upgrading. When the two problems happen at the same time, I was further confused. For several days, I was very frustrated. My host provider stepped in to solve the first problem. The second problem, is somewhat solved. The website is now running fine. However I can’t edit the database through phpMyAdmin. The database is in UTF-8, but using phpMyAdmin I can’t make the Chinese characters being displayed correctly. This is very strang. If you know where the problem comes from, I’ll be glad to hear your suggestion and comments.
