昨天,校党委宣传部的W老师打电话向我寻求帮助,说中南民大论坛MySQL数据库发生故障,他们试图用5月7日的数据库备份去恢复,但没有成功。我晚上回宿舍后,登录到民大论坛服务器上一看,原来是论坛MySQL数据库的一张MySQL表损坏。根据我的经验,成功修复MySQL损坏表的概率是90%,根本没有必要急着去用旧的数据库备份去恢复,何况备份又不及时,5月7日到发生故障的5月22日,意味着要丢失15天的数据啊。

  我修复了5月22日的数据库,故障发生之前的数据没有丢失。方法很简单,四步即可搞定。

  ①、用root帐号从命令行登录MySQL:
  mysql -u root -p

  ②、输入root帐号的密码。

  ③、选定数据库名(本例中的数据库名为studentmis):
  use studentmis;

  ④、修复损坏的表(本例中要修复的表为smis_user_student):
  repair table smis_user_student;

  点击在新窗口中浏览此图片

  注:以上操作适用于MySQL的MyISAM表存储结构。

Tags: ,



技术大类 » 数据库技术 | 评论(66) | 引用(0) | 阅读(53065)
telegram Email Homepage
2024-10-26 13:47
Just downloaded Telegram, and I’m loving it! The speed and security are impressive, plus there are so many features to explore. If you’re looking for a great messaging app, I highly recommend giving Telegram a try! 纸飞机 envy
telegram Email Homepage
2024-10-26 13:48
This article provides a practical guide to making an XLR microphone cable tester, which is great! If you also like DIY electronic projects, I recommend you to join some related audio DIY groups  on Telegram? Telegram安卓下载
telegram Email Homepage
2024-10-26 13:48
Can we chat on Telegram,Spend some time playing. I’m interested in finding out more because I have strong views about it. Would you please provide more details to your blog post? We will all actually gain from it,Here is the download link  电报apk
telegram Email Homepage
2024-10-26 13:48
Join millions of users worldwide and experience fast, secure, and feature-rich messaging. Whether you want to connect with friends, join groups, or follow channels, Telegram has it all. 小飞机下载
telegram Email Homepage
2024-10-26 13:48
纸飞机apk groups have been discussing various DIY audio tools like this! Your LED indicators are such a practical way to show cable issues, especially when working with phantom power. It’s great to see how everyone has their own approach to testing gear.”
telegram Email Homepage
2024-10-26 13:48
In one of the tg下载communities, they shared a similar idea but with a twist for detecting intermittent faults. Your setup looks more solid though, especially with the clear LED indicators. Phantom power testing is a great addition!”
分页: 4/4 第一页 上页 1 2 3 4 最后页
发表评论
表情
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
打开HTML
打开UBB
打开表情
隐藏
记住我
昵称   密码   游客无需密码
网址   电邮   [注册]