Mysql Error 145! whats up!?

flashmafia · September 7th, 2003, 7:29 PM

Ok everything was fine, and then today for no reason what so ever it seems, a table in a db, generated this:

Code:

 Can't open file: 'ppl_online.MYI'. (errno: 145)

Error

SQL-query : 

SHOW KEYS FROM `ppl_online`

MySQL said:

Can't open file: 'ppl_online.MYI'. (errno: 145)

when i opened it in phpMyAdmin. And this error:

Code:

 Can't open file: 'ppl_online.MYI'. (errno: 145)

on the page which was supposed to read from that table. And i cant find a way to fix this. I had to drop the table and reenter it in the db. That data in that table wasnt too important, but if this happens with another one il be really screwed with my site. So please if anyone knows how to prevent or fix that when it happens, then please post it here.

**patrickb** · September 7th, 2003, 8:09 PM

In PHPMyAdmin, goto the 'operations' tab for that table, and try check table then repair table. This usually will fix that problem you were having...

snide · September 7th, 2003, 10:10 PM

If you can't fix it, give support an email.

September 7th, 2003, 7:29 PM	#1 (permalink)
flashmafia Registered User Fresh Surpasser Joined in Aug 2003 7 posts Gave thanks: 0 Thanked 0 times	Ok everything was fine, and then today for no reason what so ever it seems, a table in a db, generated this: Code: Can't open file: 'ppl_online.MYI'. (errno: 145) Error SQL-query : SHOW KEYS FROM `ppl_online` MySQL said: Can't open file: 'ppl_online.MYI'. (errno: 145) when i opened it in phpMyAdmin. And this error: Code: Can't open file: 'ppl_online.MYI'. (errno: 145) on the page which was supposed to read from that table. And i cant find a way to fix this. I had to drop the table and reenter it in the db. That data in that table wasnt too important, but if this happens with another one il be really screwed with my site. So please if anyone knows how to prevent or fix that when it happens, then please post it here. __________________

September 7th, 2003, 8:09 PM	#2 (permalink)
patrickb the one who was Super #1 Joined in Jul 2003 Lives in Memphis 1,967 posts Gave thanks: 0 Thanked 3 times	In PHPMyAdmin, goto the 'operations' tab for that table, and try check table then repair table. This usually will fix that problem you were having... __________________ Patrick Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

September 7th, 2003, 10:10 PM	#3 (permalink)
snide Registered User Super #1 Joined in Jul 2003 Lives in So. NJ 1,557 posts Gave thanks: 0 Thanked 9 times	If you can't fix it, give support an email. __________________ Dime13 \| Pass17

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)