How to rebuild my WordPress Database

Hi there, I made the mistake of launching into a 2.31 upgrade a little light-heartedly, mostly because all of my previous upgrades had worked so seamlessly and I had just written another site in 2.31 afresh with no issues. Hmmm… anyway, cut a very long story down to a sentence or two, I now have a site that upgraded OK but does not allow me to edit or create post or pages without giving me grief, such as these messages:

WordPress database error: [Table ‘wp_term_relationships’ is read only]
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES (’82’, ‘1’)

WordPress database error: [Table ‘wp_term_taxonomy’ is read only]
UPDATE wp_term_taxonomy SET count = ‘0’ WHERE term_taxonomy_id = ‘1’

Warning: Cannot modify header information – headers already sent by (output started at ……….. public_html/wp/wp-includes/pluggable.php on line 391

I had problems with Alex Rabe’s Next Gen gallery allowing me to make any further changes after the upgrade. Deleting his tables from the database and reinstalling his plugins did the trick., I just recreated the galleries from scratch and it now works fine.

I am now wondering whether a similar trick could work here: Export all my Posts etc.. empty the relevant tables and then re-import the data.

Do you think that would work? Basically, I am looking for a way to force through a rebuilding of the database (upgrade.php didn’t work completely) just so can run this site.

I can’t unfortunately go back to an old backup so, given this situation, I would really appreciate some advice. fortunately it is only one site out of many that we run but it is a very important one.. thank you. ??