Not logged in. · Lost password · Register
Forum: News and announcements RSS
Moved this forum to a new database server
Now running MySQL 5.0 with Unicode
Avatar
Yves (Administrator) #1
User title: UNB developer & webmaster
Member since Jan 2004 · 3814 posts · Location: Erlangen, Germany
Group memberships: Administrators, Members
Show profile · Link to this post
Subject: Moved this forum to a new database server
Hi folks,

please excuse the outage this evening, I was moving this board to another MySQL server and had some trouble with it. Not only is 100,000 rows (or alternatively 4 MB) too much for phpMyAdmin to dump it, I also figured out that I didn't remember my own board password anymore (thanks to login cookies and browsers storing passwords) and mixed up MySQL usernames a bit while struggling with my low upstream bandwidth... ;)

Well, here we are back again, this time on a MySQL 5.0 server with full Unicode support on the back end. It took me some time adjusting the character set for all tables and columns separately. It looks as if it works fine, please report any remaining errors to me, should there be any.

Of course, this change on the backend doesn't mean a lot to you users. But since I found out that MySQL 4.0 is totally unsupported for a while already, I decided to move everything to the other MySQL server which is already running in parallel on my server. (I skipped the 4.1 version.) And who knows, maybe it's faster or something... :)

[Update]
Okay, I found one already. Anything that doesn't fit in the latin1 character set got lost in the conversion process. Since this only seems to affect the playground forum, I'm not going to get it back.
♪ ...nanananah, all in all we’re just brilliant thieves, nanananah... ♪♬
This post was edited on 2007-02-11, 23:23 by Yves.
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
This board is powered by the Unclassified NewsBoard software, 20110527-dev, © 2003-2011 by Yves Goergen
Page created in 166.4 ms (80 ms) · 32 database queries in 135.7 ms
Current time: 2012-02-07, 20:24:30 (UTC +01:00)