Dalar, can you
[:"red"] highlight in RED in your instructions that the old data has to be restored to a NEW table under a NEW name [/] and therefore the data file has to be edited at all ocurrences, where it says "w3t_post", to "w3t_post_old"? - I almost screwed up with this one.
And what about those indexes. Do they have to be renamed in the "Old" file too? Or does it not matter when w3t_post" and "w3t_post_old" use same KEY names... (This is beyond my MySql knowledge)
But I think, at least it cannot hurt, changing all those names into something else doo..
To complete your script, the OLD table should be dropped thereafter. Or you carry tons of now useless information in the database.
I think I'll give your hack a try today! - Maybe this one is about to save me hours of debats with irritated suspicious users who think that some type of big brother admin was not only killing users here but also killing their entire pasts...