posted by admin
on Wed, 07/02/2014 - 10:40
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.
Comments
Add new comment