[EMAIL PROTECTED] 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
_______________________________________________
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
