Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • 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:

Error
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.
0
idalisa
Asked:
idalisa
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>projekte.MYD
do you find that file in the mysql data directory (ie in the subfolder of the database you are using)?
0
 
idalisaAuthor Commented:
how do i look in the mysql data directory? i'm using phpmyadmin2.3.2
0
 
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
0
 
idalisaAuthor Commented:
ok - i got my projects back! i selected the file from the directory and clicked "repair". yey

:)
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

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