How can I copy blocks placement and settings between themes?
I've found this module: https://drupal.org/project/blockregion and this code to do it in the database. But both are for D6. How can I do this for D7
First, clear the existing block information for the new theme:
DELETE FROM blocks WHERE theme = 'NEW_THEME_NAME'
Now, copy all the block information from the old theme:
INSERT INTO blocks (module, delta, theme, status, weight, region, custom, throttle, visibility, pages, title, cache) (SELECT module, delta, 'NEW_THEME_NAME', status, weight, region, custom, throttle, visibility, pages, title, cache FROM blocks WHERE theme = 'OLD_THEME_NAME')
Also found this, but for D5: http://pierrerebours.com/blog/duplicating-block-settings-across-themes-drupal