More about Lightroom and sqlite

If you follow the instructions in my previous post you'll note that I was actually just renaming files, not moving them. For example, I was suggesting to rename "2012/January 03" to "2012/01_03", but you can also move the entire folder to a nested subfolder, replacing the space with '/', so replace "2012/January 03" with "2012/January/03".
However this requires an additional step:

• the folder "January" in LR database needs to be an entity of its own: if you blindly replace "January 03" with "January/03", LR will see folder "03" correctly as part of the catalog, but not its parent "January"; so, for example, you'll see "January (500 pictures)" in LR folder tree, but clicking on "January" you won't see anything, even with "display pictures from subfolders" enabled.
• the simplest fix for this is: copy a single jpeg file in all the folders 2013/January, 2013/February, ... 2012/January, 2012/February... 

for n in $(find . -type d -d 2 | grep "\./20"); do cp ~/Temp/test.jpg $n/; done

• then run "Synchronize folder" from LR, deselect "don't import duplicates", import all the copies of your jpeg and trash them immediately after