Importing old data

Alfons managed to export existing WordPress data, which I imported over here this very morning.

What I basically did was updating (update set…. wp_posts/post2cat etc.) the IDs of posts and post2cat tables with the latest known entry of the dyndns site (select max(id) from wp_posts) and add this number to the IDs of the entries in the hoogervorst.ca database. Then I dumped the hoogervorst.ca database and copied the data from the dyndns site into this dump. That’s it.

I ran into a one minor problem: a dreaded 1064 MySQL error, which I traced back to non-well formed dumps generated by phpMySQLadmin (which more or less has to do with the php_magic_quotes setting): these dumps did not escape characters correctly. I jumped back to plan B (let mysqldump do the dumping), scp-ed it to the laptop, ran the tests and script on an exact copy of this site on Elsie (The Debian serve). I saw it was good and ultimately ran it in a Dreamhost SSH session.

As said, nothing really hard: it’s fun to do it in MySQL, instead of the usual Postgres affairs I do as part of my daily job.

Update 1: Most images should be accessible once again. Also, I did not merge the latest ‘Elsewhere’ links.

This entry was posted in Truro NS. Bookmark the permalink.