Changing MySQL database encoding

For some time now, I had a pending task of converting the latin1-encoded MySQL database powering this site into utf8. I finally managed to do it after getting some advice from the kind people at a Vienna WordPress meetup.

The essence is that out of all the methods suggested in the official documentation, what worked best for me was dumping all the data to a text file, marking up and encoding it as utf-8 in a text editor and then importing it into a new database (instead of working on the production DB) that we point the wp-config.php file to after everything is verified.

Continue reading Changing MySQL database encoding

Dynamic web page construction in Ubuntu – Part 1: installing a LAMP server

Introduction

In this topic (which will span through several posts) I will share my experiences in creating a dynamic web page on the example of www.epska.org, the site I am currently building on my own from scratch (unlike this blog, which is done using the Drupal CMS). It is dynamic on several levels: 

1. content is separated from design using a .css file
2. navigation menu, header and footer are separated from the content of the page by using the php include function.
3. content is dynamically extracted from a MySQL database

The business

In this first part, we will install and set up a working localhost server – for debugging or (in case you have your own server) actual hosting of the web site.

Continue reading Dynamic web page construction in Ubuntu – Part 1: installing a LAMP server