New
#1
Cloned HDD and network/DNS issues connecting to MySQL server?
Hi there,
I have a rather perplexing problem. Our work "server" (Desktop PC serving database information to workstations) has been displaying some unusual behaviour. Our practice management software used a MySQL database on the server.
Many months ago, Windows performed an update and we lost the ability for several workstations to connect to the database. The database responded with an error: "can't get hostname for your address". I decided I was going to restore a backup, but rather than overwrite the existing HDD, I purchased a drive EXACTLY the same - a 1TB WD Blue (WDC WD10EZEX-08WN4A0). I used DDRescue to clone the drive. Once the backup was restored everything ran as before and this became our new HDD.
Windows has just updated to 1803 on the server (and others) but it hasn't gone as planned. Our entire update history has been removed so we can't rollback. Anyway, I decided to clone the drive back to the original HDD first, then restore a backup from prior to the update. Lucky I tested the drive first.
When the original HDD was used, the same network connectivity issues returned. Although I can browse the shares and access the database folder on the server using Explorer, we once again have the dreaded "can't get hostname for your address" error. Switching back to the other HDD alleviates the error and the database is accessible again.
What the hell is going on here? It doesn't make any sense to me...
Thanks gurus.
Nick