Alright...here's the solution... Rename the logfiles so they're not recognized by the system and when an instance of MySQL is created it has to redo the files and...voila! We're back in business...whew!
Rick -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 7:29 PM To: CF-Talk Subject: RE: OT: How do I stop MySQL which is running as a service? This version of MySQL ( 4.1) comes with an installation routine that allows the installer to start the service as part of the installation. It's been running as a service for about two days, but when I restarted the server, suddenly it started throwing errors... Specifically... .\ib_logfile0 is of different size 0 10485760 bytes than specified in the .cnf file 0 40894464 bytes! Well, if I could find the .cnf file, I might even try to change the size! When everything is deleted and reinstalled, I'd think it could come to a consensus about what is in the databases! Bah, humbug! Rick -----Original Message----- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 6:56 PM To: CF-Talk Subject: RE: OT: How do I stop MySQL which is running as a service? you did click on the winmysqladmin.exe in the bin folder to start the service didnt you? ---------------------------------------- From: "Rick Faircloth" <[EMAIL PROTECTED]> Sent: Thursday, February 24, 2005 6:49 PM To: CF-Talk <[email protected]> Subject: RE: OT: How do I stop MySQL which is running as a service? Thanks for tip, Dave... I've already manually deleted the service, uninstalled MySQL and reinstalled. But, I'm still getting the error. I think I've found what causing MySQL from starting. In the error log it's stating that the InnoDB log file size is different from that specified in the .cnf file... problem is...I can't even find a .....cnf file on my system! Please tell me I don't have to erase my entire system and start from scratch! Rick -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 6:01 PM To: CF-Talk Subject: RE: OT: How do I stop MySQL which is running as a service? > If this blows up and I can't solve the problem, I'll just > have to re-format the drive and start from scratch, I guess... There is a service installer/uninstaller included within the Windows Resource Kit for your server platform. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196443 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
