Mysql Error 145! Can't open file: 'planets.MYI'.

crebilis · August 29th, 2003, 5:17 PM

I get the following error:

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

I have no idea what could have caused it and what it actually means...

Anyone can help? I only have it on 1 table in as far as I know 1database. Thx

LordUppity · August 29th, 2003, 6:08 PM

Hi,

Here is something for you to try. In phpMyAdmin, you can execute the following commands:

myisamchk -r table_name

and

REPAIR TABLE table_name

* You may need to put 'table_name' in single quotations. The error you are having is often associated with a change in the server, such as an upgrade of the mysql version. This always used to happen with my forum database.

crebilis · August 30th, 2003, 7:10 AM

Cool that worked

Thx a lot LordUppity

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

August 29th, 2003, 5:17 PM	#1 (permalink)
crebilis Registered User Fresh Surpasser Joined in Aug 2003 Lives in Belgium 18 posts Gave thanks: 0 Thanked 0 times	I get the following error: Can't open file: 'planets.MYI'. (errno: 145) I have no idea what could have caused it and what it actually means... Anyone can help? I only have it on 1 table in as far as I know 1database. Thx

August 29th, 2003, 6:08 PM	#2 (permalink)
LordUppity Registered User Fresh Surpasser Joined in Aug 2003 Hosted on D19 7 posts Gave thanks: 1 Thanked 0 times	Hi, Here is something for you to try. In phpMyAdmin, you can execute the following commands: myisamchk -r table_name and REPAIR TABLE table_name * You may need to put 'table_name' in single quotations. The error you are having is often associated with a change in the server, such as an upgrade of the mysql version. This always used to happen with my forum database.

August 30th, 2003, 7:10 AM	#3 (permalink)
crebilis Registered User Fresh Surpasser Joined in Aug 2003 Lives in Belgium 18 posts Gave thanks: 0 Thanked 0 times	Cool that worked Thx a lot LordUppity

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