There might be hardcoded links in the theme; download it and do a multifile search with a text editor. Editing the text dump destroys serialized data; see another Q/A here: Why is my database import losing text widget data? Update 4/19/2015 To correctly change URLs in the database, the SQL queries below will work when … Read more
Note: This is more a comment than an answer, but I wanted to format it nicely. I don’t know about recording, but I imagine something like the following in SQL could work. INSERT INTO DB1.Tbl1 ( id, x, y ) SELECT DB2.Tbl1.id, DB2.Tbl1.x, DB2.Tbl1.y FROM DB2.Tbl1 ON DUPLICATE KEY UPDATE x=x, y=y; Beware, this is … Read more
Reset permalinks at Dashboard>>Settings>>Permalinks and be sure WP says it was able to make changes to the .htaccess file, or make the changes yourself it fails to write to .htaccess. Did you change installed directories? I.e., from /wordpress/ to root? If so, see http://codex.wordpress.org/Moving_WordPress And if you moved to a Windows IIS server, be sure … Read more
I don’t think you will find any comprehensive or easy answer for this. I think the way you already broke down the various aspects of your installation is the key – i.e., thinking of changes to files as different from changes to the database. Most of the changes I make are at the file level … Read more
It would appear that as of today, there is no easy automated way to do the migration. Closing this out.
Turn off commenting in your old blog using the following Plugin http://wordpress.org/extend/plugins/disable-comments/ Then turn off the new user registration from Settings->General by unchecking “Anyone can register” Hope it will help 🙂
Is there a clean separation between the WP tables involved with presentation vs content? I would say “no”. There is no clean separation. There is mostly-separation. Most of your content is in the post and taxonomy tables, and most of your presentation is the options table. But you also have things like sticky post IDs … Read more
Any difference between dev and prod is bad. Here is what I do: Have a different ip for dev server (Whether internal, external, or on local computer is unimportant) — but dev server must be the exact same setup (see bottom paragraph) Change the hosts file (see here) (on yours or a testing computer or … Read more
Try using the 10up/MU-Migration command: https://github.com/10up/MU-Migration
Before getting into Importing, I would familiarize yourself with both the standard post type and post_meta as well as custom post types and taxonomies. If your end goal would benefit from the latter, you will save yourself quite a bit of headache utilizing them during the import preparation. If you prefer working with the database … Read more