Master:
# 1    repair mysql database                  
exp
Online no
State
Grouping Member
Class class4
Score 298
Wealth 194
Posts 230
Login 10:43:01
Repairing MyISAM mySQL Tables/Databases:

cd /var/lib/mysql/DBNAME
#^ Please note that we assume your mySQL data directory is /var/lib/mysql

myisamchk *.MYI


Repairing ISAM mySQL Tables/Databases:

cd /var/lib/mysql/DBNAME
#^ Please note that we assume your mySQL data directory is /var/lib/mysql

isamchk *.MYI
Hits: 214, Date: 2009-06-08 23:11:42
[Agree] ( 13 ) [Against] ( 14 )

# 2    this is just for checking                  
exp
Online no
State
Grouping Member
Class class4
Score 298
Wealth 194
Posts 230
Login 10:43:01
to repair, must use myisamchk -r *.MYI, for details, refer to mysql official site. It is better to have backup before repair.
Hits: 212, Date: 2009-06-09 23:42:04
[Agree] ( 14 ) [Against] ( 13 )

# 3    i have a case caused by table name                  
luke1
Online no
State 453
Grouping Super Admin
Class class4
Score 229
Wealth 51.5
Posts 213
Login 05:38:22
table name can be case-sensitive, but you can force it is not case-sensitive by configure my.cnf add a line lower_case_table_names=1

So if you set this, the uppercase table name will not work.

I don't think it is necessary, the default is case-sensitive. The first letter of table name is uppercase is good, this can be corresponding to object name in application, e.g., Java, php, that often use uppercase for class name.
Hits: 210, Date: 2009-06-09 23:50:54
[Agree] ( 14 ) [Against] ( 13 )

# 4    thanks, just fix a table                  
sunny
Online no
State
Grouping Member
Class class4
Score 116
Wealth 103
Posts 68
Login 23:38:47
cd /var/lib/mysql/auchinet/
myisamchk -r blog_details.MYI

The table blog_details was fixed.
Hits: 129, Date: 2009-08-19 03:29:32
[Agree] ( 11 ) [Against] ( 11 )

1 - 4 [ 4]

Reply: repair mysql database

*First line:


More content:


Tags:



Hint: You cannot post here before loginLogin | Register

nothing