Nah, it wasn't you. Those cables are a very common failure. We keep them in stock at our (not apple) computer store.
Normally it's just the cable. Sometimes it's the cable and the OS needs a reload (because whatever goes wrong with the cable causes the drive itself to get corrupted, but not actually physically fail).