By shane on

Hello - I need to nuke the contents of all of my 'revisions' cells in my DB for my nodes. There's a significant issues with them filling up and causing pages not to render properly. I'm very cautious when it comes to executing sweeping SQL statements because I'm not as experienced with MySQL syntax. So, I wanted to run this by all of you:
UPDATE `node` SET `revisions` = '' WHERE `nid` >= 1 AND `revisions` != '';
Obviously I want to back up my table first. I believe this should select all nodes with a current revision entry, then delete all contents of the 'revisions1' cell.

TIA for any pointers or confirmation I've got this right before I go and nuke all 913 rows revisions entries! :-)

Comments

shane’s picture

shane commented

In the absence of any feedback, I went ahead and backed up my node table then performed the SQL statement above. It appears to have nuked the revisions data as expected. My site now runs (empiically) twice as fast as it did with bloated revisions cells.