ошибка БД

[gagarin74]

Сидел, ни кого не трогал. Захожу в веб интерфейс,а там вот такая ошибка
2015-05-15 14:25:24 3: Error writing file '/tmp/MYQN5VGg' (Errcode: 28) SELECT shouts.*, DATE_FORMAT(shouts.ADDED, '%H:%i') as DAT, TO_DAYS(shouts.ADDED) as DT, users.NAME, users.COLOR FROM shouts LEFT JOIN users ON shouts.MEMBER_ID=users.ID WHERE 1 ORDER BY shouts.ADDED DESC, ID DESC LIMIT 100
2015-05-15 14:25:23 3: Error writing file '/tmp/MY7Hyc9G' (Errcode: 28) SELECT shouts.*, DATE_FORMAT(shouts.ADDED, '%H:%i') as DAT, TO_DAYS(shouts.ADDED) as DT, users.NAME, users.COLOR FROM shouts LEFT JOIN users ON shouts.MEMBER_ID=users.ID WHERE 1 ORDER BY shouts.ADDED DESC, ID DESC LIMIT 100

в программирование не селен.чего делать то ? Желательно бэкап пока не трогать.

[sergejey]

Зайти в phpmyadmin и исправить таблицу shouts

[gagarin74]

а что именно исправить ?

[gagarin74]

и как в него войти?

[denis]

сервере с МДМ набираем в браузере
http://127.0.0.1/phpmyadmin4

логин root
пароля обычно нет.

Там уже думаю разберетесь дальше.

[gagarin74]

ну не так все просто ,но вроде разобрался.
логин и пороль на базенку другие.
root
rootpsw
Проблема исправлена путем полным очищение таблицы.

[Ko/|xo3HUk]

а что именно исправить ?

Наткнулся на хорошую статью: http://habrahabr.ru/company/kingservers/blog/257291/

Мой случай:Показать

sudo myisamchk /tmp/mysql/db_terminal/*.MYI >> /tmp/myisamchk_log.txt
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/tmp/mysql/db_terminal/commands.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/tmp/mysql/db_terminal/methods.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: warning: Size of datafile is: 11201580 Should be: 11151180
myisamchk: error: Record-count is not ok; is 396030 Should be: 394254
myisamchk: warning: Found 396030 key parts. Should be: 394254
MyISAM-table '/tmp/mysql/db_terminal/phistory.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/tmp/mysql/db_terminal/pvalues.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/tmp/mysql/db_terminal/scripts.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/tmp/mysql/db_terminal/system_errors_data.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/tmp/mysql/db_terminal/system_errors.MYI' is usable but should be fixed