After my second hard disk started failing, I really thought about moving my +11000 pictures to my young main hard disk, BUT, also keep all my favorites, tags, comments in F-spot.

F-Spot

So here's how I did it:

• Close F-spot and open a Terminal.
• Make a backup copy of the F-spot database:
  

  cp -a ~/.config/f-spot/photos.db ~/.config/f-spot/photos.db.backup

• Open the database using the command-line sqlite3 tool:
  

  sqlite3 ~/.config/f-spot/photos.db

• Our old folder is "/some/old/folder" and the new folder will be "/shiny/new/folder" (make sure it doesn't already exist!), so we'll have to do this (replace with the folder names you want, at 6 spots total!):
  

  UPDATE photo_versions SET base_uri=REPLACE(base_uri,'/some/old/folder/','/shiny/new/folder/') WHERE base_uri LIKE 'file:///some/old/folder/%';
  UPDATE photos SET base_uri=REPLACE(base_uri,'/some/old/folder/','/shiny/new/folder/') WHERE base_uri LIKE 'file:///some/old/folder/%';

• Close the database:
  

  .quit

• Now mv your folder "/some/old/folder" to "/shiny/new/folder" (make sure it doesn't already exist!):
  

  mv "/some/old/folder" "/shiny/new/folder"

• Wait til everything is moved, and then open F-spot.