Ask HN: Advice for someone moving to the Bay Area from the Midwest?

I currently live and work in Ohio; I am originally from rural Kentucky. I've spent most of my life in smallish towns, and have no long-term experience with big cities (or the west coast at all). I just got a job in Silicon Valley, and within just 3 weeks, I'm moving to the Bay Area.

For now, everything is being taken care of by my employer; I will have temporary housing and the moving expenses will be covered.

Apart from this, I have very little idea what to expect. I realize there are tons of threads like this, but a few are a little old -- and a lot of the "askers" are looking for jobs (instead of having one lined up).

I don't want to move and attempt to recreate my current life in a new location... I want to completely embrace the city life.

What should I keep in mind when dealing with the locals, especially in contrast with people where I live now? I am expecting tons of culture shock. What are the best ways to meet people? What are some common mistakes new Silicon Valley arrivals/hires make? Who/what should I avoid? Where should I live? How will I survive without a Wal-Mart or a Meijer to buy food and everything else I need for my home?

Any advice would be appreciated. Anyone who's familiar with (or been in) this specific situation -- please chime in!