Wongm's Rail Gallery » Home

Recent uploads

Last updated Sunday, 5 December 2021 (today)

82,159 photos sorted by when they were uploaded.

  • Monday, 22 November

    1 new photo in the Transit Systems Victoria album

  • Sunday, 21 November

    57 new photos in the 707 Operations - 'Picnic Express' to Bacchus Marsh, Metro Trains Melbourne - Northern group, Stored Comeng trains at Tottenham Yard and North Shore, Bacchus Marsh Coaches, Melbourne broad gauge freight, Kastoria Bus Lines, V/Line to Bacchus Marsh and V/Line to Ballarat, Ararat and Maryborough albums

  • Saturday, 20 November

    61 new photos in the Stored Comeng trains at Tottenham Yard and North Shore, Metro Trains Melbourne - Northern group, Commercialising commuters, Melbourne suburban passenger information displays, 707 Operations - 'Picnic Express' to Bacchus Marsh, ARTC trackwork, Bikes at Melbourne stations, Bus stops and infrastructure in Victoria, CDC Geelong, Grounded wagons, carriages and trams, Metro Tunnel segment manufacturing facility, Pacific National interstate steel trains, Road coaches, Southern Shorthaul Railroad standard gauge grain, V/Line - Regional Rail Link, V/Line - Standard gauge to Albury, V/Line around Geelong, V/Line carriage interiors, V/Line rail replacement coaches and V/Line workshops, yards and shunting albums

  • Friday, 19 November

    3 new photos in the V/Line - standard gauge VLocity testing and Bus bits and pieces albums

  • Thursday, 18 November

    34 new photos in the Qube Logistics Apex quarry train, V/Line - Regional Rail Link, Metro Trains Melbourne - Northern group, Transit Systems Victoria, Qube Logistics standard gauge cement train, Pacific National Tocumwal freight, Transdev Melbourne, NSW TrainLink in Victoria, V/Line around Melbourne and Pacific National - North East standard gauge freight albums

  • Wednesday, 17 November

    75 new photos in the Metro Trains Melbourne - inner suburban, City Loop, Melbourne electric multiple unit interiors, Transit Systems Victoria, V/Line - Regional Rail Link, Metro Trains Melbourne - Caulfield group, Metro Trains Melbourne - Northern group, Metro Trains Melbourne - Burnley group, Ventura Bus Lines, Melbourne stations and infrastructure, Transdev Melbourne, Southern Shorthaul Railroad works trains, Melbourne suburban passenger information displays, Melbourne tram tracks, Dysons Bus Services, Melbourne signals and signalling equipment, Surrey Hills and Mont Albert level crossing removals, Yarra Trams - Melbourne's northern suburbs, Commercialising commuters and Blackburn Road level crossing removal project albums

  • Tuesday, 16 November

    22 new photos in the Southern Shorthaul Railroad Bendigo transfers, Transdev Melbourne, Transit Systems Victoria, Metro Trains Melbourne - Northern group, V/Line - Regional Rail Link, Kastoria Bus Lines, Metro Trains Melbourne trackwork and Qube Logistics standard gauge cement train albums

  • Monday, 15 November

    110 new photos in the Yarra Trams - Melbourne CBD and Docklands, Metro Trains Melbourne - inner suburban, Transit Systems Victoria, Melbourne electric multiple unit interiors, Metro Trains Melbourne - Northern group, Melbourne suburban passenger information displays, Flinders Street Station, Transdev Melbourne, CDC Melbourne, V/Line bits and pieces, Metro Tunnel works at South Kensington, Public transport response to the Coronavirus pandemic, V/Line - Regional Rail Link, Melbourne suburban bits and pieces, Bayside Coaches, Melbourne Art Trams 2021, City Circle Tram, Metro Tunnel works at CBD South, Melbourne tram bits and pieces, Vandals and scroats, Road coaches, Melbourne tram stops and Flinders Street Viaduct albums

On this day

10 years ago, 5 December 2011

Citadis 206 at the Rundle Mall tram stop.

80,000 photos!

Wednesday 15 September 2021 21:00 PM

It's taken sixteen years, but today I passed a milestone in photos uploaded to this site - 80,000!

This is the first time I've actually noticed such a milestone - I hit 10,000 photos way back in April 2009, 25,000 photos in April 2012 and 50,000 photos in August 2017.

Here's to a few thousand more!

Shooting myself in the foot

Thursday 22 July 2021 22:12 PM

The other night I did my usual updates to the web server that drives this website, and in the process I managed to blow away all of my data! Thankfully it's all back to normal now, and it only took me a few hours of wasted effort!

The backstory

My attempt to upgrade my webserver nuked the symlink to the data directory, then my attempt to recreate the symlink to get stuff working again, I deleted the actual data!

I have automated backups of the web server and the MySQL database, but I don't have automated backups of the data directory.

I eventually worked out how to recreate a working symlink to the data directory - I never documented it in my server build plan.

The next step was to reupload the 78900+ deleted files from my local backups, then check to see how out of sync that backup is!

On the upside, I had the database side of the restore working rather quickly and all of the metadata was available - I just need the files they describe to hurry up and get onto to the cloud - only 27.3 GB of data to upload! 

By monkeying around with my SFTP settings I was able to max out my upload bandwidth - have gone from 8 Mb/s to 9.5 Mb/s. Eventually it finished at 7.30am this morning.

The rest of the time has been syncing the out of date directory tree of files with what the database says was the "real" hierarchy. I did this by running SQL queries to generate bash scripts to move files to where they're supposed to go, and then create another set of scripts to delete duplicate files.