Migrating my old mysql blog database to a new blog software (PluggedOut)
By jeltsch on Tue, 03/06/2007 - 22:40We 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