I have a live site and a backup/dev version of the site.
For some reason (probably because I did an export from Moveable Type then moved everything from localhost to a live environment I had little control over), the live site has several posts which have been cut short at special characters. The backup version has the full versions of these posts, but the ID values are different.
I'd like to merge my backup wp_posts table with the live wp_X_posts (it's on multisite - again, no control over this), updating post_content on live with post_content on backup where post_name matches.
My MySQL is failing me right now. Can anyone help?