New topics: Your Pet, IOU, Baby IQ, The Poisons, Birther II, Games, Future Power

Trying out the documentation theme?

Skip to end of metadata
Go to start of metadata

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
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
  1. Dec 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

Add Comment