A man has miraculously survived nine hours trapped under thousands of tonnes of cheddar after a collapse at a cheese warehouse.