If you see these types of error messages from MySQL database:#

Database failed to execute query (query) 1016: Can't open file: 'sometable.MYI'. (errno: 145)

Error Msg: 1034: Incorrect key file for table: 'sometable'. 

You can check and repair the table from a mysql prompt as follows: (mysql prompt is available from your DB admin tool within Plesk – phpmyAdmin)

check table sometable;

+------------------+-------+----------+----------------------------+

| Table | Op | Msg_type | Msg_text | 

+------------------+-------+----------+----------------------------+ 

| yourdb.sometable | check | warning | Table is marked as crashed | 

| yourdb.sometable | check | status | OK | 

+------------------+-------+----------+----------------------------+ 

repair table sometable;


+------------------+--------+----------+----------+ 

| Table | Op | Msg_type | Msg_text | 

+------------------+--------+----------+----------+ 

| yourdb.sometable | repair | status | OK | 

+------------------+--------+----------+----------+

Your table should now be fine

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-1) was last changed on 24-May-2017 15:30 by UnknownAuthor
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 1635

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1