<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[张宴的博客]]></title> 
<link>http://zyan.cc/index.php</link> 
<description><![CDATA[Web系统架构与底层研发]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[张宴的博客]]></copyright>
<item>
<link>http://zyan.cc/post/244/</link>
<title><![CDATA[MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>张宴 &lt;net@s135.com&gt;</author>
<category><![CDATA[数据库技术]]></category>
<pubDate>Wed, 23 May 2007 14:41:29 +0000</pubDate> 
<guid>http://zyan.cc/post/244/</guid> 
<description>
<![CDATA[ 
	　　昨天，校党委宣传部的W老师打电话向我寻求帮助，说中南民大论坛MySQL数据库发生故障，他们试图用5月7日的数据库备份去恢复，但没有成功。我晚上回宿舍后，登录到民大论坛服务器上一看，原来是论坛MySQL数据库的一张MySQL表损坏。根据我的经验，成功修复MySQL损坏表的概率是90%，根本没有必要急着去用旧的数据库备份去恢复，何况备份又不及时，5月7日到发生故障的5月22日，意味着要丢失15天的数据啊。<br/><br/>　　我修复了5月22日的数据库，故障发生之前的数据没有丢失。方法很简单，四步即可搞定。<br/><br/>　　①、用root帐号从命令行登录MySQL：<br/>　　mysql -u root -p<br/><br/>　　②、输入root帐号的密码。<br/><br/>　　③、选定数据库名（本例中的数据库名为studentmis）：<br/>　　use <span style="color: #FF0000;">studentmis</span>;<br/><br/>　　④、修复损坏的表（本例中要修复的表为smis_user_student）：<br/>　　repair table <span style="color: #FF0000;">smis_user_student</span>;<br/><br/>............<br/><br/>Tags - <a href="http://zyan.cc/tags/php/" rel="tag">php</a> , <a href="http://zyan.cc/tags/mysql/" rel="tag">mysql</a>
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment86</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>jitaolee &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Wed, 23 May 2007 23:59:27 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment86</guid> 
<description>
<![CDATA[ 
	我现在正在学习mysql,感觉现在搞网站管理,不懂mysql是迈不开步的.
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment127</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>稚鹰 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Sat, 09 Jun 2007 01:51:03 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment127</guid> 
<description>
<![CDATA[ 
	呵呵,中南民大论坛MySQL数据库发生故障的同时,在民大的另一个网站的数据库也出现了同样的错误,解决方法也是同样的方法。
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment149</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>浪人 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 21 Jun 2007 08:31:22 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment149</guid> 
<description>
<![CDATA[ 
	我修复发生<br/>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that<br/>corresponds to your MySQL server version for the right syntax to use near &#039;tabe<br/>rco_cert<br/>repair tabe rco_cert&#039; at line 1
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment150</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>浪人 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 21 Jun 2007 08:47:55 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment150</guid> 
<description>
<![CDATA[ 
	移了一下数据库语法不对喃
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment151</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>浪人 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 21 Jun 2007 09:11:21 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment151</guid> 
<description>
<![CDATA[ 
	Warning: Cannot modify header information - headers already sent by (output started at D:\APMServ5.2.0\www\phpMyAdmin\export.php:150) in D:\APMServ5.2.0\www\phpMyAdmin\libraries\header_http.inc.php on line 13<br/><br/>导出后是这样的<br/>Warning: Cannot modify header information - headers already sent by (output started at D:\APMServ5.2.0\www\phpMyAdmin\export.php:150) in D:\APMServ5.2.0\www\phpMyAdmin\libraries\header_http.inc.php on line 14<br/><br/>Warning: Cannot modify header information - headers already sent by (output started at D:\APMServ5.2.0\www\phpMyAdmin\export.php:150) in D:\APMServ5.2.0\www\phpMyAdmin\libraries\header_http.inc.php on line 15<br/><br/>Warning: Cannot modify header information - headers already sent by (output started at D:\APMServ5.2.0\www\phpMyAdmin\export.php:150) in D:\APMServ5.2.0\www\phpMyAdmin\libraries\header_http.inc.php on line 16<br/><br/>Warning: Cannot modify header information - headers already sent by (output started at D:\APMServ5.2.0\www\phpMyAdmin\export.php:150) in D:\APMServ5.2.0\www\phpMyAdmin\libraries\header_http.inc.php on line 19
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment245</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>久久乡情网 &lt;tuzwu@qq.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 16 Aug 2007 09:53:37 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment245</guid> 
<description>
<![CDATA[ 
	就这么四步就可以解决问题吗？很想试一试的，不过我一直没出现过问题！还请多指教！<br/>不错的文章哦，支持一下！
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment783</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>骆驼 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 13 Mar 2008 08:17:23 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment783</guid> 
<description>
<![CDATA[ 
	mysql版本的问题，升级到mysql5.1.22即可解决。
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment2033</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>fei &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Fri, 21 Nov 2008 06:58:31 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment2033</guid> 
<description>
<![CDATA[ 
	修表其实也会丢数据。
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment6923</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>小华 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 30 Sep 2010 06:29:30 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment6923</guid> 
<description>
<![CDATA[ 
	你好&nbsp;&nbsp;请问怎么判断的事数据表损坏
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment7856</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>最好的巧克力品牌 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Fri, 25 Feb 2011 09:22:44 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment7856</guid> 
<description>
<![CDATA[ 
	<a href="http://www.seo5200.com" target="_blank">最好的巧克力品牌</a> <br/>&lt;a href=http://www.seo5200.com&gt;最好的巧克力品牌&lt;/a&gt;<br/>seo52002011353761593-2011.2.25
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment7944</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>中华 &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 10 Mar 2011 07:37:51 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment7944</guid> 
<description>
<![CDATA[ 
	我站数据库有故障了<a href="http://www.xjdwx.com" target="_blank">www.xjdwx.com</a>
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment14145</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>louis vuitton uk &lt;fsf@fdg.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Wed, 23 Nov 2011 00:45:13 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment14145</guid> 
<description>
<![CDATA[ 
	This <a href="http://www.louisvuittonoutlets.org.uk" target="_blank">louis vuitton uk</a> for sale belongs to the sounding just what are termed as Louis Vuitton vintage best sellers, many other products and services for the reason that range appearing companies.You will easily notice the unfold zippers of this <a href="http://www.coachoutletstoreonlinefree.com" target="_blank">coach outlet store online</a>. That is the decoration. There are some inside pockets for you as well. They are easy to match your clothes and to carry.Let us inspire your inner beauty with fine <a href="http://www.christian-louboutinsale.org.uk" target="_blank">christian louboutin sale</a>. Purse the elegance in bridal wedding. Enjoy the fashion.
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment17313</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>chanel uk &lt;xiang1234xiangxiang@gmail.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Fri, 13 Apr 2012 09:12:42 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment17313</guid> 
<description>
<![CDATA[ 
	<a href="http://www.chanelukoutlets.org.uk" target="_blank">chanel uk</a><br/><a href="http://www.burberryukoutletuk.org" target="_blank">burberry uk</a><br/><a href="http://www.poloralphlaurenuks.org" target="_blank">ralph lauren uk</a>
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment17333</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>chanel uk &lt;xiang1234xiangxiang@gmail.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Fri, 13 Apr 2012 09:18:57 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment17333</guid> 
<description>
<![CDATA[ 
	<a href="http://www.christianlouboutinukuk.org" target="_blank">christian louboutin</a><br/><a href="http://www.tiffanyuksuk.org" target="_blank">tiffanys</a><br/><a href="http://www.gucciukbeltuk.org" target="_blank">gucci uk</a><br/><a href="http://www.frsaclouisvuittonsac.com" target="_blank">louis vuitton sac</a>
]]>
</description>
</item><item>
<link>http://zyan.cc/post/244/#blogcomment18618</link>
<title><![CDATA[[评论] MySQL数据库故障解决──修复损坏的表[原创]]]></title> 
<author>coach factory outlet &lt;fgf@hotmail.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 17 May 2012 02:41:19 +0000</pubDate> 
<guid>http://zyan.cc/post/244/#blogcomment18618</guid> 
<description>
<![CDATA[ 
	Today, following half a century, mentor leather-bases <a href="http://www.coachfactoryoutletao.net" target="_blank">coach factory outlet</a> continues to be the delicate craft of leather-based master is accountable for,Would you like to meet more friends, or go with the times? If yes, <a href="http://www.coachfactoryoutletao.net" target="_blank">coach factory online</a> is opening welcome doors to you.in the market you definitely can find various colorways that are designed in as well as the high quality that applied in. For most of you would like to come. So just come to our <a href="http://www.coachfactoryoutletao.net" target="_blank">coach factory outlet online</a> store to choose one.
]]>
</description>
</item>
</channel>
</rss>