These steps are for Confluence 2.9.1, done when the wiki is offline:
examples for a space called drafts:
Delete all the links related to the space:
DELETE FROM LINKS WHERE (DESTSPACEKEY = 'drafts')
Get the spaceid for the space:
SELECT SpaceID,SpaceName,SpaceKEY FROM Spaces WHERE SPACEKEY='drafts'
DELETE FROM [CONTENT] WHERE (SPACEID = 819203) AND (TITLE <> 'Home') -- DELETE FROM [CONFANCESTORS] WHERE DESCENDENTID IN (SELECT CONTENTID FROM [CONTENT] WHERE (SPACEID = 819203) AND (TITLE <> 'Home')) -- DELETE FROM [BODYCONTENT] WHERE CONTENTID IN (SELECT CONTENTID FROM [CONTENT] WHERE (SPACEID = 819203) AND (TITLE <> 'Home')) -- DELETE FROM [LINKS] WHERE CONTENTID IN (SELECT CONTENTID FROM [CONTENT] WHERE (SPACEID = 819203) AND (TITLE <> 'Home')) -- DELETE FROM [EXTRNLNKS] WHERE CONTENTID IN (SELECT CONTENTID FROM [CONTENT] WHERE (SPACEID = 819203) AND (TITLE <> 'Home')) -- DELETE FROM [Spacepermissions] WHERE SPACEID=819203 -- SELECT SPACEDESCID FROM Spaces WHERE SPACEID=819203 -- UPDATE SPACES SET SPACEDESCID = null WHERE SPACEID=819203 -- UPDATE SPACES SET HOMEPAGE=null WHERE SPACEID=819203 -- DELETE FROM [BODYCONTENT] WHERE CONTENTID=786479 -- DELETE FROM [CONTENT] WHERE ContentID=786479 -- DELETE FROM BODYCONTENT WHERE CONTENTID in (SELECT CONTENTID FROM CONTENT WHERE (SPACEID=819203)) -- UPDATE CONTENT SET PARENTID=null WHERE SPACEID=819203 -- UPDATE CONTENT SET PREVVER=null WHERE SPACEID=819203 -- UPDATE CONTENT SET PREVVER=null WHERE PREVVER IN (SELECT CONTENTID FROM CONTENT WHERE SPACEID=819203) -- DELETE FROM [CONTENT] WHERE (SpaceID=819203) -- SELECT * FROM CONTENT WHERE SPACEID=819203 -- DELETE FROM SPACES WHERE SPACEID=819203
Labels:
None
1 Comment
comments.show.hide-
-
Permalink
Add CommentDec 06, 2011
Anonymous
I created a temporary space.
Moved small bits from the laaaaarge space I wanted to delete to this temp space.
Deleted the temp space.
Did this procedure several time, until all gone.
Cheers,
Stefan, beecom.ch