This morning i woke up to a stabbing pain at the base of my fifth metatarsal. i was unable to walk properly. however, an hour later the pain was gone.?

It is likely: That you put excessive pressure on this area while you were sleeping causing nerve and/or muscle trauma which was only temporary. Unless you had an injury of some type or this is a chronic condition, that is the probable cause.

See below: The way you where sleeping may have put pressure on the nerve & once you got moving it stretched out.