My migration to a new server for all the web-based projects I’m hosting has been going great … until now. This morning, I woke up and was working on my main computer when I noticed that my server wasn’t kicking up every few minutes to refresh the OSM planet database. I turned on the screen… Continue reading Trouble in paradise
Month: January 2022
Migrating MySQL5.6 to MySQL8.0
Whew, this turned out to be quite problematic for one of my oldest databases with spatial data. The problem turned out to be that MySQL5.6 was quite flexible with how you used spatial datatypes. I had a table with a POLYGON data type, but I had stored a bunch of LINESTRING geometries instead. MySQL5.6 …… Continue reading Migrating MySQL5.6 to MySQL8.0
di2stats.com migration
One of my longest running projects with many thousands of users now is the website di2stats.com. I just added this message to the import page and disabled the import functionality so that I can migrate the database and file data to a new server. I started the migration process this morning (which I will detail… Continue reading di2stats.com migration
Mybiketraffic.com
Well, it has been three years since I last wrote here. That doesn’t mean I haven’t been busy! Quite to the contrary, shortly after my last post in 2018, I launched probably my most ambitious project yet: https://mybiketraffic.com At the same time, my long time friend, mentor, and colleague, Steve Donaldson, passed away and I… Continue reading Mybiketraffic.com