database/mySQL experts?

[pilotdave 0]

Alright, it's off topic, but I know there must be some of you out there. I made a nice mySQL database of all the videos on my FTP server. The main table seems to have gone corrupt or something. It won't open. All the data's still in there - I can open the file with notepad and see it. But mySQL won't display the table and I can't query it through Access or a php web page. Anyone have any clue how I might be able to fix it?
Dave
http://www.skydivingmovies.com

[cyberskydive 0]

What are you running it off of? Any error messages? What version? How are you trying to access the information / extract values?
.....there is no spoon
--------------------
My website

[pilotdave 0]

Running in mySQL 3.23.49 in windows 98, running in an dos prompt window...
mysql> select * from tbl1;
ERROR 1030: Got error 127 from table handler
When i try to access it through a php script, I get no data. In Access it gives me an ODBC error of some kind.
I tried to find error codes in the mySQL documentation but couldnt find em anywhere.
Dave
http://www.skydivingmovies.com

[indyz 1]

After backing up the database (shit happens) try running the command "REPAIR TABLE tbl1". I would suggest using the mySQL command shell instead of PHP to run the query because you will probably get more verbose messages. If you don't know how to use it, either myself or one of the other geeks around here can walk you through it.
--
Brian

[pilotdave 0]

You're my new hero! That fixed it. My own server will only be up for a few more days (till friday), but if anyone wants to do any searches for movies on the skydivingmovies.com ftp server, you can still do it at http://129.2.156.19/phptest/view_data.php. Perhaps we can get that running on AndyMan's server or somewhere else. THANKS!!!!
Dave
http://www.skydivingmovies.com