I have spyview up at all time- 5 minutes ago it just 'cleared' - that is I saw a server connection error page, then a few seconds later a 'no data to be displayed' page for a few seconds until some clicks came in, and then spyview came back but started 'fresh' (only 1 entry on the page).

Is this anything anyone else has experienced?

I'm migrating everything to a beefy dedicated server this week, just hoping nothing is wrong with my DB (which I just exported).

If I view an 'overview' or 'visitors' all my data from this morning is there, it was just interesting.

Never heard of this but something similar about data missing while web host updating software that affects the data. Yours is a little different because you're just moving host. However as a note SPY should clear clicks automatically for clicks that are over 24 hours old. However that doesnt sound like that you're going through. Not sure what it is off hand

SPY view is on a memory table, whenever the server is restarted or mysql server is restarted the memory table will be cleared. No worries the clicks are still recorded, the spy view is just going to show empty!