OK here's the steps I took in case someone else wants to do this.
verify data -
select count(*) from ubbt_import_map where post_id not in (select post_id from ubbt_posts);
156289 posts
prepare for delete based on post ID -
Added post_id primary key to ubbt_import_map
remove obsolete rows -
delete from ubbt_import_map where post_id not in (select post_id from ubbt_posts);
removed 156289 rows
optimize table -
size in db tools – started at 3mb
optimized – now at 64k
Let me know if you have any questions!
