Fork me on GitHub

Database Syncing

Database syncing allows you to keep your database in sync across multiple devices. You can sync your database using either Dropbox or a private HTTP server.

Sync Using Dropbox

Dropbox is the easiest way to sync your database across multiple devices. All you need to do is save your UPM database file to your Dropbox folder. Dropbox takes care of syncing the database to all your devices.

For the best experience on Windows/Mac/Unix ensure you're using UPM 1.9 or later. This version monitors the currently open database file and alerts you if it changes.

If you're using an Android device you'll need place your database file in a special Dropbox folder (<Dropbox Root>/Apps/UPM) to ensure UPM can see it. See Using Dropbox on Android for more details.

Sync Using HTTP

Using a HTTP/HTTPS server is a little more complicated than using Dropbox. You'll need your own webserver capable of hosting PHP scripts. If you don't already have one you'll need to purchase a web hosting service. A quick google for "web hosting" should throw up quite a few options.

The webserver should be accessible from each machine and device you want to share the database between.

Server Side Steps

At present UPM supports HTTP and HTTPS. The URL can be password protected by basic authentication.

Two PHP files are required on the webserver, deletefile.php and upload.php. Both of these files come packaged with the desktop version of UPM in the .\server\http directory. Alternatively they can be downloaded directly from here.

The directory containing your password database along with the deletefile.php and upload.php scripts should be secured using,

Sample Apache config,
    <Directory "/var/www/upmdir">
      AuthType Basic
      AuthName "Restricted Content"
      AuthUserFile /etc/httpd/.htpasswd
      Require valid-user
To create the password file use,
htpasswd -c /etc/httpd/.htpasswd <user name>
(your hosting provider may provide a GUI for doing this)

In UPM create an account with the same username and password as created with htpasswd.

In your UPM "Database Properties" select the account you just created for "Authtentication Credentials".

Client Side Steps