[SOLVED] odd database error upon deletion of a table

[Derleek]

"#6 - Error on delete of './moto/benchRacers.MYI' (Errcode: 2)"

 

Not quite sure what that means, i was trying to recreate a table because some of the data was incorrect and i get that message when i delete it to try again.

 

When i look at the table through phpMyAdmin the 'records, type, coalition, size, and overhead' all say "in use"

 

never seen this.

 

Also when i try and insert something into it it gives me the error "File './moto/benchRacers.MYD' not found (Errcode: 2)"

 

here is the table create syntax

 

$benchracers = "CREATE TABLE benchRacers(
id INT, 
pick_id INT,
racer_id INT, 
race_id INT,
paid INT)";
mysql_query($benchracers) or die(mysql_error());

[Derleek]

could my database just be corrupt?