After a major linux crash, me and my colleagues decided to move our PHP and
mySQL stuff over to NT. it has run stabily thus far. in order to move the
old data off teh old linux server, we actually had to export the tables to
ms access and run an access to sql module to put it into something mysql can
read.
unfortuantely, thsi script seemingly neglected to add that our ID fields
were indexed field, and thus all our join queries are stalling mysql.
additionally, when we try to index our ID fields, the server hangs when we
attempt to change the field properties to NOT NULL. we are using the
shareware version of mysql for win32. any ideas to aid me in this problem
would be helpful.
thanks,
Ryan Norris / Web Developer
Boston Medical Center
rynorris@stripped / 617-414-6876 (M & TH)
