PluggedOut

Migrating my old mysql blog database to a new blog software (PluggedOut)

We updated my server from SuSE 9.3 to 10.1. php5 is the default on 10.1 and my blog software broke. As my blog software is not anymore maintained, I had to switch to another and I selected PluggedOut. The mysql database structures were quite different and this is what I did to do the conversion:

First I dumped the old database into textfiles:

mysqldump -u root -p --tab=/home/jeltsch/temp --fields-terminated-by=| --lines-terminated-by=# journal