mysql教程 修复数据库教程实例
Alter DATABASE [dvbbs] SET SINGLE_USER
GO
DBCC CHECKDB(’dvbbs’,repair_allow_data_loss) WITH TABLOCK
GO
Alter DATABASE [dvbbs] SET MULTI_USER
GO
使用php教程myadmin修复的过程中造成了原有数据全部丢失。在把备份恢复后，使用了myisamchk来进行修复。最后数据库修复成功
www# myisamchk -r -B pw_posts.MYI
- recovering (with sort) MyISAM-table ‘pw_posts.MYI’
Data records: 1
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
Data records: 259889
