昨天,校党委宣传部的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表存储结构。
我修复了5月22日的数据库,故障发生之前的数据没有丢失。方法很简单,四步即可搞定。
①、用root帐号从命令行登录MySQL:
mysql -u root -p
②、输入root帐号的密码。
③、选定数据库名(本例中的数据库名为studentmis):
use studentmis;
④、修复损坏的表(本例中要修复的表为smis_user_student):
repair table smis_user_student;
注:以上操作适用于MySQL的MyISAM表存储结构。
高仿包
2015-4-29 09:57
古奇包包蔻馳包包高仿包
happy wheels
2018-11-20 17:25
The information you share is great and useful. Thank you for sharing.happy wheels
temple run
2018-11-20 17:30
Information about the main functions of F5 BIG-IP is very good and useful. Thank you for sharing.Temple run
shz
2022-6-29 00:19
This is my first time i visit here and I found so many interesting stuff in your blog especially it's discussion, thank you. online dealings
shz
2022-6-29 00:24
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! online dealings
shz
2022-6-29 00:32
I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts. online dealings
shz
2022-6-29 00:39
This is my first time i visit here and I found so many interesting stuff in your blog especially it's discussion, thank you. online dealings
shz
2022-6-29 00:44
I read that Post and got it fine and informative. Please share more like that... online dealings
shz
2022-6-29 00:54
I really enjoy reading and also appreciate your work. online dealings
Lucky cola
2024-2-7 16:04
Immerse yourself in the ultimate gaming universe. Lucky cola
分页: 3/3 1 2 3