MySQL Crashed Table Unable to save result set
I have a crashed table which I am unsure how to repair with. Here is the dump of my error trace:
Warning: mysql_query(): Unable to save result set in
C:\U开发者_运维问答sers\programmer\workspace\DBMigration\functions.php
on line 10 MySQL Query Failed! 1194: Table 'exp_weblog_titles' is marked as
crashed and should be repaired
If that is MyISAM table:
- make backup of exp_weblog_titles.* files
- copy exp_weblog_titles.MYD and exp_weblog_titles.MYI to D:\work or any working directory
- run myisamchk D:\work\exp_weblog_titles --repair
- on success you may copy table back to mysql data directory
- on failure - you will get different problem
I had a problem similar to your. REPAIR command help me in my case - http://dev.mysql.com/doc/refman/5.0/en/repair-table.html
精彩评论