SMF just stopped working on RAID rebuild

[NoRad]

I had to rebuild my mirrored raid and SMF stopped working upon reboot. I think I've isolated the problem to mySQL. It's running and shows that it's working fine, but I get the following error message:

Can't find file: '.\louipimps\smf_settings.frm' (errno: 22)

Another site of mine brings up the following:
Can't open file: 'smf_sessions.MYI'. (errno: 130)

Any suggestions? I have no idea what's wrong.

[Grudge]

Sounds like the database hasn't been restored correctly to me - what does PHPMyAdmin say?

[NoRad]

When I try to navigate to the directory in c:\mySQL it says that the directory is corrupt and unreadable. =(

[Grudge]

OK. Well, I don't know much about MySQL from a shell viewpoint but I'm guessing you need to restore the backup or something similar...

[NoRad]

I'm going to try to run Scandisk first.

[Ben_S]

Your settings table is currupt, do you have a backup of it?

[NoRad]

Thanks for the help guys. Unfortunately, the stupid RAID card I have is entirely unreliable. I lost everything, but I had some backups on another drive and was able to restore that drive.

A word of advice... If you're worried about security don't run a Mirrored set. That's total BS. Run a Raid 5 or 10, but not a mirrored. It's unreliable. After every reboot you have to scan to rebuild it, and half the time the card was dropping my drive. The only exception to this might be if you have $200+ for a 3ware or adaptec SATA raid card that actually does HARDWARE raid and not that software BS (silicon image, promise, etc).

Bleh... =(

[[Unknown]]

C:\archive_d\Program Files\MySQL\bin>perror 22
Error code  22:  Invalid argument

C:\archive_d\Program Files\MySQL\bin>perror 130
Error code 130:  Unknown error
130 = Incorrect file format

Sorry about your troubles.

-[Unknown]

[Ben_S]

Check what you have in your mysql database directory, you may be lucky and still have the important tables.

[NoRad]

I see several tables there, but what can I do with them? Just copy them over?

[Ben_S]

It depends on if all the files that make up the table are there and if they are damaged on not, I'd suggesr making a copy of everything then do a test install somewhere, then use phpmyadmin and drop broken tables and import the ones from the fresh install. Obviously if the messages table etc are broke then you may have to start again, but it's worth a try.

[NoRad]

I tried this and while it looked like some of the files might have worked, those important were corrupt. To make things worse, the windows drive letter changed from C to D for some reason (gg mirrored sets) and now I can't even log on to the system. I'm trying to get on so I can modify the registry key. Wish me luck. This has been a ******ty year. 

[NoRad]

It looks like my data might be salvagable. I was able to correct a lot of the tables, but once I got to the site the theme was broken and I couldn't login (users were lost)... I shall keep trying.

[NoRad]

+-----------------------------------------------------------+
| Msg_text                                                  |
+-----------------------------------------------------------+
| Can't open file: 'smf_attachments.MYI'. (errno: 130)      |
| Can't open file: 'smf_fc_connections.MYI'. (errno: 130)   |
| Can't open file: 'smf_instant_messages.MYI'. (errno: 130) |
| Can't open file: 'smf_log_search.MYI'. (errno: 130)       |
| Can't open file: 'smf_log_topics.MYI'. (errno: 130)       |
| Can't open file: 'smf_members.MYI'. (errno: 130)          |
| Can't open file: 'smf_messages.MYI'. (errno: 130)         |
| Can't open file: 'smf_themes.MYI'. (errno: 130)           |
+-----------------------------------------------------------+

These are the tables I'm having trouble with.  I can get them imported and login, but the messages and topics are not working properly. If I run the maint. inside of SMF it deletes like 3,000 messages without topics or something like that.

[NoRad]

What sucks is that I've had about 100 new users register in the past 2 weeks. They are all lost as well.

[Ben_S]

Does REPAIR TABLE TABLE NAME HERE help?

[NoRad]

Nope. The repair seems to ultimately remove all data inside the messages and members tables. I just said screw it and went with a backup from Dec 20th. That really hurts my forum because, like I said, I had a lot of registered users and posts since then. Oh well.

What's really crazy about this is that I had the backups for mySQL going every night, but for some reason the SMF tables for my main site were not included in that backup. My old forum and coppermine were backed up, though.

[OvermindDL1]

Might check the update script to see if it just backup's specific tables/db's, or all.

[NoRad]

It was only backing up specific tables for that database. Shame really.