Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
So I've been poking around my system and I found /usr/lib/mysql/ /usr/share/mysql/ The mod dates on these are really old. Can I delete these safely? I'm guessing the are from the Apple install. These files seem to be in the /usr/local/mysql/ path also. Hmmm... I looked at my old Mac OS

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote: Then I don't know what to say about the MyISAM error, though I'd watch InnoDB pretty carefully as I think MyISAM is pretty robust on OS X too. We did also see these when a disk is failing, but I assume you've run disk utility. I guess it co

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote: On Jul 23, 2005, at 10:14 AM, Ware Adams wrote: Has your mysql crashed or have your restarted the machine without first shutting down mysql manually? We only saw this error when mysql was not shut down normally. You can look in your .err fi

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote: Has your mysql crashed or have your restarted the machine without first shutting down mysql manually? We only saw this error when mysql was not shut down normally. You can look in your .err file which should be in your data directory. Ever

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote: I am all most ready to give up on MySQL at this point. I'm still getting regular table corruption on multiple installs of OS X. I went as far as reporting it as a bug: http://bugs.mysql.com/bug.php?id=12066 They seem to want more info but my

Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
I am all most ready to give up on MySQL at this point. I'm still getting regular table corruption on multiple installs of OS X. I went as far as reporting it as a bug: http://bugs.mysql.com/bug.php?id=12066 They seem to want more info but my requests for clarification have gone unanswered.

Re: Mac OS X Table Corruption

2005-07-06 Thread Dan Tappin
On Jul 6, 2005, at 10:26 AM, [EMAIL PROTECTED] wrote: I'm not a Mac guru but what you describe sounds like file system corruption. Can you do a diagnostic scan of your hard drives looking for bad sectors? You can move your data to another portion of the disk if you run an ALTER TABLE to ma

Re: Mac OS X Table Corruption

2005-07-06 Thread SGreen
Dan Tappin <[EMAIL PROTECTED]> wrote on 07/06/2005 11:26:13 AM: > I am running into repeatable table corruption with MySQL 4.x on Mac > OS X 10.x. > > I previously had a MySQL install on 10.2 Client under 3.x and never > had an issue or any major problems at all. I upgraded to MySQL 4.x > and

Re: Mac OS X Table Corruption

2005-07-06 Thread Dan Tappin
I had someone on the mac-osx server admin list point this out to me: http://docs.info.apple.com/article.html?artnum=107852#sql which is regarding a byte-ordering issue resolved in an upgrade from OS X 10.3.2 to 10.3.3. Now in my case I could have upgraded with out performing this procedure.

Mac OS X Table Corruption

2005-07-06 Thread Dan Tappin
I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. I previously had a MySQL install on 10.2 Client under 3.x and never had an issue or any major problems at all. I upgraded to MySQL 4.x and have subsequently installed MySQL 4.x (from the supplied pkg's) on my