Solved

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

Posted on 2006-07-04
5
499 Views
Last Modified: 2006-11-18
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
Comment
Question by:idalisa
  • 3
5 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 17040287
>projekte.MYD
do you find that file in the mysql data directory (ie in the subfolder of the database you are using)?
0
 

Author Comment

by:idalisa
ID: 17040294
how do i look in the mysql data directory? i'm using phpmyadmin2.3.2
0
 

Author Comment

by:idalisa
ID: 17040342
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
 

Author Comment

by:idalisa
ID: 17040488
ok - i got my projects back! i selected the file from the directory and clicked "repair". yey

:)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question