User Macros import-export

[KPAH]

Due to Confluence limitations, I had to create lots of user macroses, and I mean over 9000 of them. I think I would be better off writing my own wiki instead of tweaking somebody's else work.

Anyway, is there a way to export these precious macros without paid (!!!) plugins?

Thanks in advance.

[Amalia · Accepted solution]

Which version of Confluence are you using now? I believe that the user macros are stored in the BANDANA table. Example, in Confluence 4.3:

SELECT bandanavalue 
FROM bandana 
WHERE bandanacontext = '_GLOBAL' AND bandanakey = 'atlassian.confluence.user.macros';

If the format is not too different between these two Confluence versions, then I believe you can copy these data and import them into the new Confluence version (after that, try to restart or flush cache).

[KPAH]

Brilliant, thanks!!

[KPAH]

Hi, thanks for quick reply. It is 4.3 standalone.

I've used Database Browser to connect to my db, which is MySQL. The transact above returns just "bandanavalue"
"(BLOB)"

Am I missing something?

[Amalia]

usually, you will be able to double click the BLOB to see the data. Otherwise, use the MySQL command line instead

[pdr]

To export this in an importable way, use mysqldump:

mysqldump -t confluence BANDANA --where="bandanacontext = '_GLOBAL' AND bandanakey = 'atlassian.confluence.user.macros'" > usermacros.sql

You'll then need to shutdown your new instance, then from mysql do:

delete from BANDANA where BANDANACONTEXT='_GLOBAL' AND bandanakey = 'atlassian.confluence.user.macros';

Then import the record from the other instance before starting up confluence again:

mysql confluence < usermacros.sql

[Matthew J. Horn]

9000 macros?! I thought *I* used alot of macros. Wow!