This week I had to switch a MySQL DB from a latin-1 host to a UTF-8 host (Webserver with Forum/CMS). I have never managed to make this work with only setting the codepages right.
I have put together a perl script that takes the databases and their tables from the one host, encodes it to UTF-8 and inserts the data in the new host.
I hope someone finds this useful: sqlcopyconv.txt
PS: You need to have all the Tables in the new DB created already. But without data.
I got back to playing with Xen again now.
I set up a new box and installed xen via
apt-get install xen-linux-system-2.6.18-6-xen-686.
In the syslog I had heaps of errors like:
Feb 1 11:29:09 test33-10 kernel: 4gb seg fixup, process sshd (pid 2583), cs:ip 73:b7bd59bc
Feb 1 11:29:16 test33-10 kernel: printk: 261591 messages suppressed.
I found out that this was because of libc6-xen was missing. So installing this one, solved the problem for me.
For my other wordpress installation (www.ff-pitten.at) I had the problem, that IE would not break (wrap) a line of many pictures into multiple lines (e.g. http://www.ff-pitten.at/2008/01/06/pkw-bergung-nach-vu-auf-a2/).
The fix for this is to specify “float: left;” in the css for the images.
So easy, but nowhere to be found…
Playing around with WordPress for another homepage which will have a lot of pictures I discovered the slimbox plugin which I think is really nice. Continue reading “WordPress and automatically use slimbox for pictures”
I recently played around a bit with Xen. As always I use Debian as my choice. With Etch it was actually pretty easy to use it.
Continue reading “Debian Etch and Xen”
I recently got a new phone which runs Windows Mobile. Since this also has a fairly good IMAP Client and using webmail sucks a bit on these small devices, I wanted to use it.
Continue reading “SMTP delivery to port 587 (submission) with a Windows Mobile Device”
Seems I’ve got myself a new toy now.
I thought about starting a blog since some time already. Now I took the time and did it.
Continue reading “New toy…”