I like to note some SQL data manipulation comment in the case of ‘folder moving’ vs PL database just a few months ago. For example: you move manually folder like: c:\photos\2025 → d:\allyear\2025 and PL database not know the photos in the new place. Its works fine, you not lose any keyword, project linking, etc.
Win database script (works fine)
I have a better script now. Works with sub-folders and more elegant.
I think its straightforward, commented. Test with one case with few sub-folders, works fine.
/* NOTE: Variables
variable string expected between '' like: 'sting' Example: 'moonshine_folder' and NOT moonshine_folder
variables: var_src_folder_name -> the source folder name ; var_dst_folder_name -> the destination folder name. Note: just a folder name, and not full path!
*/
/* Script Part 1 - Update the 'main' folde…
Nice solution under Mac (works fine):
The DB of PL for Windows is different from the one for Mac. Here’s what to do on Mac:
[Screen @ 2025-12-22 um 08.31.26]
Steps - DO NOT SKIP ANY OF THEM!
in PL, make a database backup (with the command nested in the file menu)
quit PL, then delete it’s cache files or folders (they are recreated by PL later)
with Finder, copy the old Foto Archive to the new drive
open a DB Browser for SQLite and open PL’s database (not the backup)
select the Browse Data tab and the ZDOPFOLDER table
breathe, l…
May check thru the whole thread add a few bit.
p.s.: also some SQL stuff for List PL keywords , and also for Keyword import and Keyword + Photo linking import to PL