Update - I took a VM snapshot before I ran it in Heidi SQL.. All worked except the last 2 queries I think.
/* SQL Error (104
: Column 'spell_id' cannot be null */
/* Affected rows: 2,514 Found rows: 0 Warnings: 0 Duration for 2,502 of 2,504 queries: 23.189 sec. */
I reverted the snapshot. Please advise, thanks.