I'm running version 5.0.22-community-nt of MySQL. For some reason, InnoDB
is disabled. I have it installed on my XP Pro machine, and it's working
fine, and one on a Windows 2003 server, which is working fine, and another
on a Windows 2003 server, which is the one with a problem.
At one point, this server was a replication slave. I recently stopped the
replication process so I could use it as a separate server. I didn't notice
any issues with it until this one. When I try to make a table an InnoDB,
it's not available as a selection in SQL Manager. When I do a SHOW ENGINES,
InnoDB is listed as DISABLED. when I edit My.ini and try to make InnoDB the
default engine, then the MySQL Service will not restart. I've come to rely
on InnoDB, because it allows foreign keys. Otherwise, I have to write
queries to remove child records manually
Does anyone have any suggestions?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]