Change the path of images in the Shotwell database

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP








up vote
1
down vote

favorite












I moved my picture library to a different folder, how can I change the path in the Shotwell database?







share|improve this question


























    up vote
    1
    down vote

    favorite












    I moved my picture library to a different folder, how can I change the path in the Shotwell database?







    share|improve this question
























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I moved my picture library to a different folder, how can I change the path in the Shotwell database?







      share|improve this question














      I moved my picture library to a different folder, how can I change the path in the Shotwell database?









      share|improve this question













      share|improve this question




      share|improve this question








      edited May 2 at 21:47

























      asked Apr 21 at 16:28









      Alex

      2851427




      2851427




















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          1
          down vote













          Shotwell stores it's data in a SQLite database. You can change the path as follows:



          • close Shotwell

          • make a backup of ~/.local/share/shotwell/data

          • sqlite3 photo.db


          • type a command like this:



            sqlite> update PhotoTable set filename = replace(filename, '/old/path/', '/home/me/new/path/') where filename like "/media/media%";






          share|improve this answer






















            Your Answer







            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "89"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: false,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













             

            draft saved


            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1026987%2fchange-the-path-of-images-in-the-shotwell-database%23new-answer', 'question_page');

            );

            Post as a guest






























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            1
            down vote













            Shotwell stores it's data in a SQLite database. You can change the path as follows:



            • close Shotwell

            • make a backup of ~/.local/share/shotwell/data

            • sqlite3 photo.db


            • type a command like this:



              sqlite> update PhotoTable set filename = replace(filename, '/old/path/', '/home/me/new/path/') where filename like "/media/media%";






            share|improve this answer


























              up vote
              1
              down vote













              Shotwell stores it's data in a SQLite database. You can change the path as follows:



              • close Shotwell

              • make a backup of ~/.local/share/shotwell/data

              • sqlite3 photo.db


              • type a command like this:



                sqlite> update PhotoTable set filename = replace(filename, '/old/path/', '/home/me/new/path/') where filename like "/media/media%";






              share|improve this answer
























                up vote
                1
                down vote










                up vote
                1
                down vote









                Shotwell stores it's data in a SQLite database. You can change the path as follows:



                • close Shotwell

                • make a backup of ~/.local/share/shotwell/data

                • sqlite3 photo.db


                • type a command like this:



                  sqlite> update PhotoTable set filename = replace(filename, '/old/path/', '/home/me/new/path/') where filename like "/media/media%";






                share|improve this answer














                Shotwell stores it's data in a SQLite database. You can change the path as follows:



                • close Shotwell

                • make a backup of ~/.local/share/shotwell/data

                • sqlite3 photo.db


                • type a command like this:



                  sqlite> update PhotoTable set filename = replace(filename, '/old/path/', '/home/me/new/path/') where filename like "/media/media%";







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Apr 21 at 16:29









                George Udosen

                17k93559




                17k93559










                answered Apr 21 at 16:28









                Alex

                2851427




                2851427



























                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1026987%2fchange-the-path-of-images-in-the-shotwell-database%23new-answer', 'question_page');

                    );

                    Post as a guest













































































                    Popular posts from this blog

                    pylint3 and pip3 broken

                    Missing snmpget and snmpwalk

                    How to enroll fingerprints to Ubuntu 17.10 with VFS491