I’m moving my blog to a new host. First I exported the MySQL database (created with pMachine 2.3). Then I installed pMachine 2.4 on my new host. Everything was fine until I imported the database.

The pMachine 2.4 MySQL structure is different. For example, the pm_weblog table has at least two new fields (sticky and sent_pings). When I imported the old file, it deleted the new fields. I manually added those fields, but it seems that the same thing happened in other tables (I’m getting lots of debug errors).

I’ve tried several different ways of exporting the data, but the new fields are always deleted. Obviously I’m doing something wrong. There must be a way to add the data to a database without changing the structure.

I’d appreciate any tips you can offer.

Doh! Never mind. As usual, I was making it much more difficult than it really is. It certainly helps to read the documentation.