Long, long ago I hacked together a Java app that imports the freedb CD info files from my local drive to an MS Access database. The CD ripper application I use creates a local freedb with a file for each CD I rip (all of them). So importing from that freedb to a database seemed a natural thing to do.
Access was all that I had access (heh) to, and it had a “music collection” database template, so with slight modification to the template that’s what I used.
Well now, I no longer have access (heh) to Access, Access is a PITA, and I already have MySQL available on my home server, so I figured it was time to finally migrate.
I found a handy application called Navicat (fully functional trial), that will import directly from the Access .MDB file to a MySQL database.
While Navicat mostly worked, I was not quite done. The import did not properly get the auto_increment attribute on the tables’ ‘id’ column. Also, the Access database tables had spaces in their names which is kind of a drag. Fortunately both were easily solved by exporting from MySQL to text using mysqldump, editing the .sql file that resulted, and then reimporting to MySQL from the .sql file.
Sure it’s a ridiculous thing nobody in their right mind will ever have to do, but I’m not in my right mind.
It’s a long way away, but we finally got up there to do this loop. Starting with about 5.5 miles climbing on the road, you then get another 5 miles or so of singletrack climb. This singletrack is minimally technical; just a good steady climb.
Once at the top, there are some beautiful views back into Rocky Mountain National Park from the top. A spur of trail (that we didn’t take) gets you to the true summit of Crosier.
Then it’s 4.5 miles of descent, some of it pretty sketchy and loose, but still pretty fun.
In February, after my 3rd knee surgery since 2005, I had no plans or expectations for my riding this summer. And when all my friends made the commitment to a Whistler, BC trip in April, I just figured I was out. But as the summer got going, I was feeling pretty good, and riding pretty clean, and got the big encouragement from Steph, so I was in after all.
Scheduling difficulties meant that I would only get 3 days there instead of the 5 my friends would, but nevertheless, I was in.
We flew into Seattle, and rented a couple of cars there. Flights to Vancouver were 2 or more times the price. It means twice the driving, and add a border crossing, but we figured it was worth it to save a couple hundred each for 7 people.
The Whistler Bike Park is incredibly well managed, and loaded with great riding. There are ride-arounds for most of the big and committing features. I spent 2 days there, and 1 day riding Vancouver’s North Shore.
It was incredible riding. There’s a reason half the photos in bike magazines are from BC. I thought maybe this was a once in a lifetime trip, but now I sure hope it isn’t.
The bike park was amazing fun, but next time I want more North Shore. The incredible amount of work done there to build trails and mind-blowing stunts was astounding.
Friends of Tom from SoCal were there at the same time we were, and very very kindly showed us around the bike park, and especially the North Shore. They were very patient with our (meaning my) slow pace.
Park bikes are very heavy and don’t really pedal at all. They’re kind of inappropriate for my riding style on North Shore rides.
So for me, park bike for park days, trail or all-mountain bike for the other stuff.
We had a condo, but the days were long and tiring, so we ate out all the time. Restaurants in Whistler are breathtakingly expensive. We could have hired a chef to cook for us in the condo and still come out ahead.
There’s no good beer there. And it’s expensive. Buy in Bellingham, WA on your way in. (In fairness, we did receive this tip from others, but were too preoccupied with getting there.)
Body armor and full-face helmets get pretty sweaty and stinky. Since it’s somebody else’s stink, rented armor and rented full-face helmets are even worse. At least buy your own helmet.