NYCPHP Meetup

[nycphp-talk] ism tables.

Hans C. Kaspersetz hans at cyberxdesigns.com
Tue Jan 9 08:52:27 EST 2007


mikesz at qualityadvantages.com wrote:
> 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
>

I meant to say that when I ran ALTER TABLE phpbb_users ENGINE = MYISAM 
on 4.0 it wiped any data that was in the tables out of them and returned 
an empty myi file. 

Hans
A little fun from a NJ web design company, http://www.cyberxdesigns.com



More information about the talk mailing list