Moving Files and Folders in Adobe Lightroom by Manipulating the Database

Many of us use Lightroom for our photo collection.   Explaindio Video Bundle 2020 ReviewThere are occasions when you want to move the files to a different location. Renaming folders on a system is very quick and easy but breaks the link between the files and Lightroom. I know Lightroom can move the photo collection but for various reasons the files and folders had already been moved to a new location outside of Lightroom so I needed a way to tell Lightroom that the files and structure had moved.

I knew that Lightroom keeps all the file information in an sqllite database and using Firefox I could access it. The instructions here were completed on a Lightroom 2.5 database. I have not checked this with any other version. Before we start. If you follow this advice I recommend you backup your Lightroom data file in case this goes wrong.

I downloaded SQLite Manager for Firefox available from Once installed run SQLite Manager (Tools menu then SQLite Manager) This is a superb graphical display to help you manipulate a database file. SQLite will open with no database selected. You will need to use the Open Folder icon to navigate to the Lightroom data file. The tooltip will show you that this icon is called "Connect Database". We now need to open the data file.

https://usainfo.org/explaindio-video-bundle-2020-review/