tmsss/delete node revisions.mysql

Created January 26, 2016 16:04

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tmsss/6b569a908262055c6293.js"></script>
Save tmsss/6b569a908262055c6293 to your computer and use it in GitHub Desktop.

Download ZIP

Delete node revisions from database

Raw

delete node revisions.mysql

DELETE FROM `node_revisions` WHERE node_revisions.vid NOT IN (SELECT node.vid FROM `node` );

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment