Hard drive crashed... could use "help for dummies"

[MiniD]

I set the MySQL server up some time ago and remember very little about it. Yesterday I had a hard drive error after rebooting and I can no longer boot the drive. I was able to "recover" the disk enough to get the db files off of it, but I'm not sure how to get the mysql databases back up and running.

What I've done so far:

Installed Mysql 4.1 (what I was running before)

I have no idea where to go from here. I did do a search, but nothing really captured my situation and, to be honest, I need something relatively simple to follow.

Any help is appreciated.

Dave

[Jerry]

Which operating system was the MySQL server on ?

[MiniD]

The server is Win 2003 EE.

[MiniD]

I have the php info up and running at:

http://www.fatdrunkbastards.com/forums/phpinfo.php

[MiniD]

I have installed MySQL administrator and also done the following:

I've coppied the file from "data" titled "VBulletin" to the new MySQL data directory. When I run MySQL Administrator, I can see files under "catalogs". I've done a "check tables" maintenance on all of them and they come up good.

[MiniD]

The database seems to be present and accounted for, I just don't seem to be able to connect to it. I've checked "Use old passwords" in the administrator, but I'd like to enter the command for it... except I can't remember how to get to a place where I can enter a command.

I disappointed in how much I have forgotten about this setup.

[MiniD]

OK... I figured out the old password setup which brings me to the last remaining problem:

I get this error:

postindexCheckError: Can't open file: 'postindex.MYI' (errno: 130)

And this error:

subscribethreadCheckError: Can't open file: 'subscribethread.MYI' (errno: 130)

The Forums start up ( http://www.fatdrunkbastards.com/forums/index.php )

It does not do it if you enter a forum while a guest, only when you log in.

[Marco van Herwaarden]

Try to repair those tables from your AdminCP->Maintenance.

You might need to run it a few times.

[MiniD]

Yeah... I've tried that more than a few times. I've also tried the repair custom indexes option. Both to no avail.

[MiniD]

I got it up and running. I stumbled across the dos command line information for rebuilding the indexes and the gentlemen at VB sent me simillar information with a few extra options. Unfortunately, the myisamchk program cannot work with MYI files that it is unable to open. I ended up compying another MYI file to the two needed names and then rebuilt that. It did the trick.

Thanks for the help.