mysql损坏后的灾难恢复

来源:互联网 发布:网络威胁人身安全 编辑:程序博客网 时间:2024/05/01 23:19
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
今天启明中文的数据库在服务器的意外掉电中损坏,使用phpmyadmin修复的过程中造成了原有数据全部丢失。在把备份恢复后,使用了myisamchk来进行修复。最后数据库修复成功
www#myisamchk-r-Bpw_posts.MYI
-recovering(withsort)MyISAM-table‘pw_posts.MYI’
Datarecords:1
-Fixingindex1
-Fixingindex2
-Fixingindex3
-Fixingindex4
-Fixingindex5
-Fixingindex6
Datarecords:259889
www#
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
原创粉丝点击