Knowledgebase: General Q&A
Can't open file: 'ec3_ad.MYI'
Posted by - NA - on 16 February 2006 12:17 PM
An error like this typically means that the file associated with that particular database table is damaged

(MySQL errno: 145 Can't open file ec3_ad.MYI).

You can repair the table in one of the following ways:

1/ Through Esvon Classifieds Admin Area :
Go to Admin Area > SQL Command section and run this SQL query :

repair table ec3_ad
[replace ec3_ad with your table name here]

2/ Through phpMyAdmin :

select the appropriate table and then tell the phpMyAdmin to repair it or just run the same SQL query from phpMyAdmin to your database.

3/ Through shell access to MySQL (if you have it):

enter the MySQL prompt from the shell:

mysql -u dbuname -h dbhost -p dbname;

where dbuname, dbhost and dbname are exactly the same as in your
inc/application.php - you will also be prompted for your password, which must also be the same
as in inc/application.php - and try the REPAIR TABLE command:

repair table ec3_ad;
[replace ec3_ad with your table name here]

Comments (0)
Help Desk Software by Kayako Fusion