• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • Last Modified:

phprojekt - errno:145 - repair table - "table doesn't exist"

I am using PHProjekt and cannot access the projekte database. This happened when I tried to delete one project. Now, when I click on "projekte" menu, I can't see all of my projects and instead get the following:

SQL-query :  
SHOW KEYS FROM `projekte`
MySQL said:
Can't open file: 'projekte.MYD'. (errno: 145)

When I go the SQL and type: REPAIR TABLE projekte.MYD -- I get:

projekte.MYD repair error Table 'projekte.myd' doesn't exist

Sadly, I don't have any backup. Have I lost ALL my projects information? Please help! I need to have this fixed by today! Thank you.
  • 3
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
do you find that file in the mysql data directory (ie in the subfolder of the database you are using)?
idalisaAuthor Commented:
how do i look in the mysql data directory? i'm using phpmyadmin2.3.2
idalisaAuthor Commented:
Additional info:

I don't know if this helps in answering my question, but when viewing my database structure under myphpadmin, the summary fields display:

Table: projekte
Action:  Browse  Select  Insert  Properties  Drop  Empty  (I cannot select "browse", "select" or "empty" option)
Records: in use
Type: in use
Size: in use
idalisaAuthor Commented:
ok - i got my projects back! i selected the file from the directory and clicked "repair". yey

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now