2011-11-06 What started out as being too tired to work on mmh, resulted in a very productive work ``flow'' until deep in the night. The impor- tant decision had been to try to get the web-space to real-server move finished. I already had done the easy parts weeks ago, but the difficult ones were still to do. (I don't talk about the really big ones: Mail and name server.) What I started today is moving the most complicated of my websites. This one needs a data base, sends mails, and similar stuff. I copied the files from the webspace into a parallel location on the server. Again, curlftpfs had been a great helper. Then I in- stalled mysql and learned to control it. Up to now, I never did much with the command line client; just used phpmyadmin. This time ends now. It took some time to get used to mysql and remember the common commands. Also, I needed to care about user management, which is not under your control if you have only a webspace. During the database migration, I cared to convert everything to UTF-8. People on the Internet wrote a lot about that -- real horror stories. I needed to filter for valuable in- formation, but then I had few problems. Adjusting the PHP scripts to handle the UTF-8 data correctly had been more difficult. (The interesting point is htmlentities().) On the server I run lighttpd, whereas the webspace had been served by apache. Lighttpd doesn't support .htaccess files, thus I needed to convert those. With some examples, this was easy. The PHP scripts are of low programming quality, because they had been written by a novice, years ago -- me. ;-) E.g. Register Glo- bals was the default back then and my scripts depended on it. Hence, I needed to adjust here and there. (Should rewrite large parts of the scripts, but ... you know: There's too much more ap- pealing stuff to do.) Then mail sending. Although I have no public mail system set up, there is masqmail installed to transport mail within the local machine. I made it able to deliver mail to the outside world, too. Voila: The PHP scripts could send mails. There are still a lot more things to do, but (unexpectedly) I made a giant leap today. http://marmaro.de/lue/ markus schnalke