昨天,校党委宣传部的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: ,
技术大类 » 数据库技术 | 评论(41) | 引用(0) | 阅读(31189)
jitaolee
2007-5-24 07:59
我现在正在学习mysql,感觉现在搞网站管理,不懂mysql是迈不开步的.
稚鹰
2007-6-9 09:51
呵呵,中南民大论坛MySQL数据库发生故障的同时,在民大的另一个网站的数据库也出现了同样的错误,解决方法也是同样的方法。
浪人
2007-6-21 16:31
我修复发生
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'tabe
rco_cert
repair tabe rco_cert' at line 1
浪人
2007-6-21 16:47
移了一下数据库语法不对喃
浪人
2007-6-21 17:11
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

导出后是这样的
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

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

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

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
久久乡情网 Email Homepage
2007-8-16 17:53
就这么四步就可以解决问题吗?很想试一试的,不过我一直没出现过问题!还请多指教!
不错的文章哦,支持一下!
骆驼
2008-3-13 16:17
mysql版本的问题,升级到mysql5.1.22即可解决。
fei
2008-11-21 14:58
修表其实也会丢数据。
小华
2010-9-30 14:29
你好  请问怎么判断的事数据表损坏
最好的巧克力品牌 Homepage
2011-2-25 17:22
最好的巧克力品牌
<a href=http://www.seo5200.com>最好的巧克力品牌</a>
seo52002011353761593-2011.2.25
中华 Homepage
2011-3-10 15:37
我站数据库有故障了www.xjdwx.com
louis vuitton uk Email Homepage
2011-11-23 08:45
This louis vuitton uk 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 coach outlet store online. 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 christian louboutin sale. Purse the elegance in bridal wedding. Enjoy the fashion.
coach factory outlet Email Homepage
2012-5-17 10:41
Today, following half a century, mentor leather-bases coach factory outlet 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, coach factory online 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 coach factory outlet online store to choose one.
louis vuitton sale Email Homepage
2012-5-17 10:41
Louis Vuitton belt at louis vuitton sale is one kind of fashion accessory with high cost performance among the Louis Vuitton accessories.Offering quality LV products with favorable prices, louis vuitton outlet store is at your service. Hurry up, or you can not seize the chance.in fact, louis vuitton is one of the most famous fashion design master.he opened the fist suitcase shop called after his name.
coach outlet online Email Homepage
2012-5-17 10:41
I heard of coach outlet online through the advertisement when I was shopping. And now I often brow the webpage and buy Coach bags online.It is a symbol regarding position not to mention nature.Here I would like to launch a excellent bags pertaining to business men.Which may be coach outlet store.coach outlet has always been simple,durable style features to win consumers.The products are more flexible,with easy bleaching,wear characteristics,and simply use a damp cloth.
coach outlet, Email Homepage
2012-5-17 10:41
Remember the coach outlet provide coach bags which won't be deteriorated into its overall styles by any means. It will maintain its looks, colors, and uniqueness for long time.coach outlet store online has been voted by Hour Detroit magazine readers as the Best of Detroit in their 12th annual readers'poll.Lots of women like which usually amount normally include a coach outlet online ,it provides coziness to many girls that don't even think it is a great bushel of great interest directly to them.
xujie777 Email
2012-5-18 15:40
We aim to make all our customers satisfy with our products. You will find a variety of Men's fashion louis vuitton uk, fashion Women's cheap Louis Vuitton bags in our store at affordable price.Thinking of interesting ways to cost a milestone birthday? louis vuitton online shop had one of the most distinctive distinctive celebrations.bakery along with living room operated by means of about three moment louis vuitton online Most effective Pastry Chef’s of the year Rammy Nominee Chef’s.
xujie777 Email
2012-5-18 15:40
The choices are likely to be basically countless seeing that louis vuitton outlet occurs with the help of completely new and also incredible concepts once in a while.Louis vuitton Wholesale Monogram Canvas HandbagsLouis Vuitton Collection Beach Handbags louis vuitton bags outlet Damier Canvas HandbagsLouis vuitton Mahina HandbagsLouis Vuitton Monogram Mini Lin HandbagsLouis Vuitton Monogram Multicolore HandbagsLouis vuitton Monogram Vernis HandbagsLouis Vuitton Wholesale Epi Leather HandbagsLouis Vuitton For Men HandbagsLouis Vuitton Damier Canvas WalletsLouis Vuitton Epi Leather WalletsLouis Vuitton Monogram Canvas WalletsLouis Vuitton Monogram Vernis WalleLouis Vuitton ShoesLouis Vuitton Men wallets.As the Authentic Louis Vuitton are so high-priced, so came the louis vuitton handbags outlet.
分页: 1/3 第一页 1 2 3 下页 最后页
发表评论
表情
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
打开HTML
打开UBB
打开表情
隐藏
记住我
昵称   密码   游客无需密码
网址   电邮   [注册]