I have been using open-source web-based photo album organiser Gallery for a long time, starting (around 2003) with Version 2 and now on (the final) Version 3. In fact it’s been so long ago that I have forgotten why I made the decision initially, except vaguely recalling something along the lines that I was looking an application based around PHP and MySQL (around the time the term LAMP stack was coined) photo gallery software Gallery, and there wasn’t anything else as feature-rich and user friendly at the time. My needs are fairly basic so I have not re-evaluated other choices since upgrading to Gallery 3.
Now, due to the recent decision to move host, I discovered two things while attempting to migrate Gallery. One is that Gallery has not been actively maintained since 2014. The second thing is that the MySQL dump from Gallery apparently exceeded the file size limit (50MB) for uploading to my new host using phpMyAdmin and the command line route is also out (certain errors during importing that I could not track down). This led to the slightly annoying situation of needing to find a new photo album software. By the way, although briefly experimenting with Flickr (which has also become history, as they say), I am more for keeping content on my own server.
A quick Google search showed I was not the only one having the same predicament. Taking the easy (ie. lazy) route I decided to follow the advice of more knowledgeable users such as the below and migrated to Piwigo. I must say, it’s been good after a week’s use.