Thanks for all the help guys, i got the info that I needed. However i am still in a bind... I am getting this error whenever I click on a video
ERROR: Unable to execute query
SELECT * FROM guest_info WHERE guest_ip=xx.xx.xxx.xxx' AND log_date='25-02-08'
Can't open file: 'guest_info.MYI' (errno: 145)
after looking around this internet I have found that this means that the guest_info table is corrupted and needs to be repaired. i found a repair command for mysql at the command prompt but it seems to not have worked as this error still comes up even after a hard power cycle to the server.
Any ideas?
the command I used was
mysql> repair table guest_info
it just sat there and did nothing, it didn't even give me a prompt line back nor did it give me a confirmation...
Bookmarks