Ave, I run MySQL 4.x on my Power Mac G5 with Mac OS X 10.3.8 with PHP5. I have been running Apache Web Server and my websites on this machine for almost 6 months now. And twice I have faced table corruption which I had to fix using REPAIR TABLE. Twice in 6 months isn't bad at all, yet, I wonder why.
Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: [EMAIL PROTECTED] http://www.informed-sources.com On 4/4/05 12:59 PM, "Brent Baisley" <[EMAIL PROTECTED]> wrote: > I've been running on OS X for a while, although I haven't had any > really heavy usage sites. I also haven't had a single corruption > problem on a live database in the 2+ years I've been running MySQL. > > Now, I say on a live database. For the first time I tried upgrading the > MySQL that comes with OSX Server. I've always used OSX client with > MySQL installed. The standard MySQL installation puts everything in > /usr/local/bin, Apple puts some stuff in /bin, but other MySQL pieces > in other places. After upgrading MySQL on OSX Server, I couldn't get it > to run until I launched Apple's MySQL Manager, which is just a start > and stop button really. Even then things weren't running right. I ended > up searching for and deleting all the pieces of MySQL I could find, > then installing the MySQL package again. What I thought was a clean > install still wasn't working. Checking things over, I realized that > permissions were wrong on some of the MySQL directories. I had > forgotten to delete the MySQL receipts file (/Library/Receipts), which > stores what OSX thinks the correct permissions should be. I fixed the > permissions manually and everything now seems to be running fine on the > test system running OS Server 10.3 on a 400Mhz G4 (ugh!). > > So, if you are trying to upgrade MySQL on OSX Server, it's far from > straight forward. Make sure you delete all of Apple's installed pieces > and delete the receipts file, then try installing the MySQL package. > > On Apr 4, 2005, at 11:00 AM, Dan Tappin wrote: > >> I have been running into issues with MySQL table corruption issues on >> a couple of OS X systems. I end up with tables that need repair every >> day and some times multiples times per day. It's so bad now that I >> have a script that runs the mysql 'REPAIR TABLE...' command and then >> the myisamck command on all the tables afterwards. >> >> I currently admin 3 OS X systems each with MySQL / PHP based websites: >> >> - G4 Tower with 10.2.x client >> - G4 Tower with 10.3.8 server >> - Dual G5 Xserve with 10.3.8 server >> >> Each of the G4's exhibits the problem. I am only developing the G5 >> site and have not seen the issue yet on this system. On each system I >> upgraded the default Apple mysql install with the pkg installer >> supplied by MySQL. The 10.2 system I am still at MySQL 4.0.x and the >> 10.3 system I am at 4.1.10 (the latest release). >> >> When I upgraded I did discover that there were some issues with the >> new version and the old Apple supplied build. Apple installs theirs >> in /bin/ and the MySQL package in /usr/local/bin/. Early on I was >> running my mysql* command i.e. myisamck etc with specifying a path. >> On the 10.2 system I ended up running the 3.* Apple versions of MySQL >> on my 4.x tables royally screwing them up. I went for far as to >> delete the old /bin/mysql* files. On the new 10.3 G4 system I learned >> from my mistakes in took care of he path issues right away so I am >> pretty sure that I did not cause the corruption by manually using the >> old /bin/ binaries. >> >> I have a suspicion that this might still be part of the problem. I >> never had an issue with mysql when I was using MySQL 3.x. I built >> that 10.2 system when Jaguar was release (end of 2002 I believe) and >> it ran 24/7 and I cant recall ever seeing these issues before. I >> switched to 4.x for many of the new features that were lacking in 3.x. >> >> I was wondering if any one else out there is running MySQL 4.x on OS X >> and has seen any issues in this regard. I have run Tech Tool on both >> systems and done full scans. I have a good UPS on both systems and >> the new 10.3 system had brand new drives. Given all of this I am >> convinced either I am unlucky and have some obscure issues on both >> systems or there is some issue with MySQL 4.x on OS X or a conflict >> somewhere with the older Apple versions supplied with the OS. >> >> Thanks, >> >> Dan T >> >> >> >> ------------------------------------------ >> Dan Tappin, P.Eng. - Senior Engineer >> O'Rourke Engineering Limited >> Calgary, AB >> (403) 298-9639 >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]