原创作品,允许转载,转载时请务必以超链接形式标明文章
原始出处 、作者信息和本声明。否则将追究法律责任。
http://navyaijm.blog.51cto.com/4647068/1347483
1
2
3
4
5
6
7
8
|
mysql> use xx_sync
Reading
table
information
for
completion
of
table
and
column
names
You can turn
off
this feature
to
get a quicker startup
with
-A
Database
changed
mysql>
desc
extension_1;
ERROR 145 (HY000):
Table
'./xx_sync/extension_1'
is
marked
as
crashed
and
should be repaired
mysql> quit
Bye
|
1
2
3
4
5
6
7
8
|
[root@yw_db_yj xx_sync]# ./bmyisamchk -r db/xx_sync/extension_1.MYI
- recovering (
with
sort) MyISAM-table
'db/xx_sync/extension_1.MYI'
Data records:
101539
- Fixing index
1
myisamchk: warning: Duplicate key
for
record at
26664372
against record at
16160720
- Fixing index
2
Data records:
101538
myisamchk: warning:
1
records have been removed
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
[root@yw_db_yj xx_sync]# ./bin/mysql -uroot -p123456 --sock=logs/mysql.sock
Welcome to the MySQL monitor. Commands end
with
; or \g.
Your MySQL connection id
is
549105657
Server version:
5.5
.
15
-log Source distribution
Copyright (c)
2000
,
2010
, 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
xx_sync
Reading table information
for
completion of table and column names
You can turn off
this
feature to
get
a quicker startup
with
-A
Database changed
mysql> desc extension_1;
+------------+-------------+------+-----+---------+----------------+
| Field | Type |
Null
| Key | Default | Extra |
+------------+-------------+------+-----+---------+----------------+
| id |
int
(
11
) | NO | PRI | NULL | auto_increment |
| passport |
var
char(
64
) | YES | UNI | NULL | |
| content | longtext | NO | | NULL | |
| checkcode |
var
char(
45
) | YES | | NULL | |
| createtime |
int
(
11
) | YES | | NULL | |
| updatetime |
int
(
11
) | YES | | NULL | |
+------------+-------------+------+-----+---------+----------------+
6
rows
in
set
(
0.02
sec)
mysql> quit
Bye
|