虚拟主机域名注册-常见问题 → 数据库问题 → MySQL | |||||||
win2003服务器 mysql数据表修复方法
确保mysql处于开启状态 在cmd命令提示符中输入: mysql -u root -p 弹出Enter password: 输入密码 再进入到数据表中如:tougao这个数据表,则输入: use tougao 回车 再输入要修复的数据表如qb_article这个表: repair table qb_article;回车 下面是命令操作截图:
C:\Documents and Settings\Administrator.EBS-29827.000>mysql -u root -p Enter password: ******** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 428 Server version: 5.1.71-community-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use tougao Database changed mysql> repair table qb_article;
|
|||||||
>> 相关文章 | |||||||
发表评论 | |||||||