Fresh install of mysql 4.1 on windows 2k3 server...issues
Posted: Wed Sep 28, 2005 2:25 pm
I just configured a new windows 2k3 server and installed mysql 4.1. I wasn't having any problems until I migrated all of the data over from my old server to the new and then tried a select off of the "new" database.
here's the kicker:
if I go to the command line and "use %database%" to my new database then do "show tables", they pop right up. but if I try to "select * from %table%" from the new database, it dies a horrible death.
and here's where it gets even weirder, if I "use mysql" and then do "show tables" it dies a horrible death. I've repeated this pattern like 5 times to make sure that it wasn't a fluke...and indeed it's not.
another strange thing, I installed mysql as a service and when I try to restart the service, it just hangs on stopping, so I end up having to reboot the new server...total PITA.
any ideas what might be happening here?
thx,
Burr
here's the kicker:
if I go to the command line and "use %database%" to my new database then do "show tables", they pop right up. but if I try to "select * from %table%" from the new database, it dies a horrible death.
and here's where it gets even weirder, if I "use mysql" and then do "show tables" it dies a horrible death. I've repeated this pattern like 5 times to make sure that it wasn't a fluke...and indeed it's not.
another strange thing, I installed mysql as a service and when I try to restart the service, it just hangs on stopping, so I end up having to reboot the new server...total PITA.
any ideas what might be happening here?
thx,
Burr