Stupidly, I truncated my posts table with out thinking about the term relationships. Now I have a bunch of 404s because there are broken term relationships. Is is possible to rebuild the table with the correct pairings?
to see which term relationships are orphans and use a
warning: Truncating your wp_term_relationships deletes everything in that table! if you want to only delete tag term relationships then make sure you use the correct sql.
After truncating the wp_term_relationships table I used a custom script to re-tag my posts. You can do something similar like this: