磁盘已满，表崩溃......没有 phpmyadmin 修复的正确方法是什么

发布于 2024-10-08 20:58:51 字数 4391 浏览 0 评论 0原文

mysql数据库文件位于一个分区中。 mysql 突然不可用，因为分区已满 100%

，所以我删除其他文件并启动 mysql。

一切都很好，但是当浏览我的网站时，有一条消息告诉我表 ./k1/cache_filter 被标记为崩溃：

* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:5798c3c8b649979ac97799d5bbf9fbc5' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<form name=\"form1\">\n<select style=\"font-size:12px;color:#8BAB6B;font-family:verdana;background-color:#ffffff;\" name=\"menu\">\n<option value=\"#\">----Submit----</option>\n<option value=\"http://www.mysite.com/node/add/komputer\">Trik</option>\n<option value=\"http://www.mysite.com/node/add/forum\">Forum</option>\n<option value=\"http://www.mysite.com/node/add/freebies\">Freebies</option>\n</select>\n<input style=\"font-size:12px;color:#ffffff;font-family:verdana;background-color:#A7CE80;\" type=\"button\" onClick=\"location=document.form1.menu.options[document.form1.menu.selectedIndex].value;\" value=\"Go\">\n</form>\n\n<div style=\"text-align: center;\"><a href=\"http://www.mysite.com/user\">&#8226; Login | Register &#8226;<br>&#8226; My Account &#8226;</a></div>', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:5798c3c8b649979ac97799d5bbf9fbc5' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:211aa9fdb9976e821c3a565826a36d16' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p align=\"center\"><script type=\"text/javascript\"><!--\ngoogle_ad_client = \"pub-8495709850146104\";\n/* eyecandy2u 160x600, created 7/10/09 */\ngoogle_ad_slot = \"1295348390\";\ngoogle_ad_width = 160;\ngoogle_ad_height = 600;\n//-->\n</script>\n<script type=\"text/javascript\"\nsrc=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\n</script></p>', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:211aa9fdb9976e821c3a565826a36d16' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:a347380abe409e26d216f14e039e66d2' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<a href=\"http://www.mysite.com/artikel/all\"><img src=\"http://img.nattawat.org/images/1wdfaq3zl5cf7czjprb9.png\"></a>', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:a347380abe409e26d216f14e039e66d2' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:5636feaceb0a27ee732eaf45616989c8' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<!-- BEGIN STANDARD TAG - 728 x 90 - ROS: Run-of-site - DO NOT MODIFY -->\n<IFRAME FRAMEBORDER=0 MARGINWIDTH=0 MARGINHEIGHT=0 SCROLLING=NO WIDTH=728 HEIGHT=90 SRC=\"http://ad.globe7.com/st?ad_type=iframe&ad_size=728x90&section=417236\"></IFRAME>\n<!-- END TAG -->', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:5636feaceb0a27ee732eaf45616989c8' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.

这是 drupal 网站。以前我使用的是 phpmyadmin。

但现在，我试图在没有 phpmyadmin 的情况下生活

，所以，在没有 phpmyadmin 的情况下修复的正确方法是什么

原文

The mysql database files is in a partition. mysql suddenly unavailable because partition full 100%

so I remove other files and start mysql.

everything fine but when browse my website, there is a message telling me that table ./k1/cache_filter is marked as crashed:

* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:5798c3c8b649979ac97799d5bbf9fbc5' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<form name=\"form1\">\n<select style=\"font-size:12px;color:#8BAB6B;font-family:verdana;background-color:#ffffff;\" name=\"menu\">\n<option value=\"#\">----Submit----</option>\n<option value=\"http://www.mysite.com/node/add/komputer\">Trik</option>\n<option value=\"http://www.mysite.com/node/add/forum\">Forum</option>\n<option value=\"http://www.mysite.com/node/add/freebies\">Freebies</option>\n</select>\n<input style=\"font-size:12px;color:#ffffff;font-family:verdana;background-color:#A7CE80;\" type=\"button\" onClick=\"location=document.form1.menu.options[document.form1.menu.selectedIndex].value;\" value=\"Go\">\n</form>\n\n<div style=\"text-align: center;\"><a href=\"http://www.mysite.com/user\">• Login | Register •<br>• My Account •</a></div>', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:5798c3c8b649979ac97799d5bbf9fbc5' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:211aa9fdb9976e821c3a565826a36d16' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p align=\"center\"><script type=\"text/javascript\"><!--\ngoogle_ad_client = \"pub-8495709850146104\";\n/* eyecandy2u 160x600, created 7/10/09 */\ngoogle_ad_slot = \"1295348390\";\ngoogle_ad_width = 160;\ngoogle_ad_height = 600;\n//-->\n</script>\n<script type=\"text/javascript\"\nsrc=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\n</script></p>', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:211aa9fdb9976e821c3a565826a36d16' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:a347380abe409e26d216f14e039e66d2' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<a href=\"http://www.mysite.com/artikel/all\"><img src=\"http://img.nattawat.org/images/1wdfaq3zl5cf7czjprb9.png\"></a>', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:a347380abe409e26d216f14e039e66d2' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:5636feaceb0a27ee732eaf45616989c8' in /home/www/html/www.mysite.com/includes/cache.inc on line 26.
* user warning: Table './k1/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<!-- BEGIN STANDARD TAG - 728 x 90 - ROS: Run-of-site - DO NOT MODIFY -->\n<IFRAME FRAMEBORDER=0 MARGINWIDTH=0 MARGINHEIGHT=0 SCROLLING=NO WIDTH=728 HEIGHT=90 SRC=\"http://ad.globe7.com/st?ad_type=iframe&ad_size=728x90§ion=417236\"></IFRAME>\n<!-- END TAG -->', created = 1293070347, expire = 1293156747, headers = '', serialized = 0 WHERE cid = '3:5636feaceb0a27ee732eaf45616989c8' in /home/www/html/www.mysite.com/includes/cache.inc on line 109.

This is drupal website. Previuosly I'm using phpmyadmin.

But now, I trying to live without phpmyadmin

so, what is the right way to repair without phpmyadmin

分享到QQ

分享到微博