[SOLVED] MySQL Error 1016: Can't open file: 'user_tracking.MYD'. (errno: 145)

We've been running osCommerce website flawlessly for over two years, but recently encountered the following MySQL error.

1016: Can't open file: 'user_tracking.MYD'. (errno: 145)

We're running mysql 3.23.58 version, and recently restarted the mysqld by killing the mysql processes. This may have corrupted the table file named above.

You may use phpMyAdmin to "repair" the corrupted table. Or, use the command line from the mysql client.

% mysql -u user -p password 
mysql> use {databasename} 
mysql> repair table user_tracking; 
+----------------------+--------+----------+--------------------------------------------------------+ 
| Table                | Op    | Msg_type | Msg_text                                              | 
+----------------------+--------+----------+--------------------------------------------------------+ 
| db.user_tracking | repair | info    | Found block that points outside data file at 223752128 | 
| db.user_tracking | repair | status  | OK                                                    | 
+----------------------+--------+----------+--------------------------------------------------------+ 
2 rows in set (52.92 sec)

You may also encounter a problem startup the mysqld process:

service mysqld start 
Timeout error occurred trying to start MySQL Daemon. 
Starting MySQL:  [FAILED] 

This may occur if you run out of disk space (i.e. / partition). Free up the space, and restart the mysqld service, and it will work.

Tags: 

Comments

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.