NYCPHP Meetup

[nycphp-talk] ism tables.

mikesz at qualityadvantages.com mikesz at qualityadvantages.com
Tue Jan 9 00:37:25 EST 2007


Hans C. Kaspersetz wrote:

> Well, I did finally get a copy of MySQL 4.0.x installed on my 
> computer.  It looks like the tables are really corrupt.   The iasmchk 
> utility wasn't able to recover them.  I am kinda bummed but live and 
> learn.  Now I have MySQL 4.0.x, 4.1.x and 5.0.x installed on my 
> computer just for this case.
>
> When I ran ALTER TABLE phpbb_users TYPE = MYISAM  in MySQL 4.0 it 
> wiped the tables clean.  They showed no records.
>
> When I ran ALTER TABLE phpbb_users TYPE = MYISAM  in MySQL 4.1 or 5.0 
> I got the same silly error I was getting earlier from MySQL.
>
> Thank for the help guys.
> Hans
>
> Jon Baer wrote:
>
>> Actually after reading your original email all you need to do is a 
>> bulk search/replace and change ...
>>
>>>> ALTER TABLE phpbb_users TYPE = MYISAM
>>>
>>
>> to
>>
>>>> ALTER TABLE phpbb_users ENGINE = MYISAM
>>>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
>
> __________ NOD32 1963 (20070108) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>
What happened when you ran "ALTER TABLE phpbb_users ENGINE = MYISAM" as 
suggested?

I also have 40, 41 and 50 running on my system and it saves me a lot of 
grief when dealing with my clients who can be running any of them...

regards, mikesz



More information about the talk mailing list