I have a database server(Fedora 14) which mysql is running as the database server. Recently that server broke down and I was only able to get the database directory from the server.
I have tried to put that database directory which I was able to get from my broke down server into a mysql server which is running on another PC (also Fedora 14) but, only three tables had data and though the table names are shown, when I try to execute queries it says table not available except for three tables. I have more that 30 tables in that database.
Please tell me a way to recover those missing tables.
I have tried to repair tables as follow but it was not success,
mysql> show tables;
+-----------------------+
| Tables_in_ofm_mnu_jvs |
+-----------------------+
| Company |
| CostCenters |
| CostVariable |
| Des_Note |
| EDN_Main |
| EDN_Sub |
| Factory |
| ICMT_Main |
| ICMT_Sub |
| IMT_Main |
| IMT_Sub |
| ItemLedger |
| JC_InOutCrop |
| JC_Main |
| Ledger |
| Log |
| OLD_Stock |
| SRN_Main |
| SRN_Sub |
| St_BFG |
| St_FGS |
| St_OGS |
| St_OLS1 |
| St_OLS2 |
| St_OLS3 |
| St_OLS4 |
| St_OLS5 |
| St_RAW |
| St_RDS |
| St_SPG |
| SysUpdate |
| Vw_AllStock |
| Vw_AllStokMove |
| Vw_AllStokMove1 |
| Vw_ExcropBalance |
| Vw_JCSummary |
| a_user |
| act_months |
| batchno |
| certification |
| e_email |
| grn_main |
| grn_sub |
| item_code |
| item_grade |
| mtn |
| san |
| stocktype |
| supplier |
| uom |
| zc_Block |
| zc_Cetification |
| zc_FarmerAccount |
| zc_FarmerCer |
| zc_FarmerCompany |
| zc_FarmerCrop |
| zc_FarmerReg |
| zc_IcsYear |
| zc_Society |
| zc_temfar_crop |
| zc_temfar_main |
| zc_user |
+-----------------------+
62 rows in set (0.00 sec)
mysql> repair table Company;
+---------------------+--------+----------+-------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+-------------------------------------------+
| ofm_mnu_jvs.Company | repair | Error | Table 'ofm_mnu_jvs.Company' doesn't exist |
| ofm_mnu_jvs.Company | repair | status | Operation failed |
+---------------------+--------+----------+-------------------------------------------+
2 rows in set (0.00 sec)
I think my tables are not MyISAM tables because when I run myisamchk *.MYI I got follwing results,
myisamchk *.MYI
Checking MyISAM file: act_months.MYI
Data records: 2 Deleted blocks: 0
myisamchk: warning: 1 client is using or hasn't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
MyISAM-table 'act_months.MYI' is usable but should be fixed
---------
Checking MyISAM file: OLD_Stock.MYI
Data records: 115375 Deleted blocks: 0
myisamchk: warning: 7 clients are using or haven't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
MyISAM-table 'OLD_Stock.MYI' is usable but should be fixed
---------
Checking MyISAM file: zc_IcsYear.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
[root@localhost ofm_mnu_jvs]# myisamchk *.frm
myisamchk: error: 'act_months.frm' is not a MyISAM-table
---------
myisamchk: error: 'a_user.frm' is not a MyISAM-table
---------
myisamchk: error: 'batchno.frm' is not a MyISAM-table
---------
myisamchk: error: 'certification.frm' is not a MyISAM-table
---------
myisamchk: error: 'Company.frm' is not a MyISAM-table
---------
myisamchk: error: 'CostCenters.frm' is not a MyISAM-table
---------
myisamchk: error: 'CostVariable.frm' is not a MyISAM-table
---------
myisamchk: error: 'Des_Note.frm' is not a MyISAM-table
---------
myisamchk: error: 'EDN_Main.frm' is not a MyISAM-table
---------
myisamchk: error: 'EDN_Sub.frm' is not a MyISAM-table
---------
myisamchk: error: 'e_email.frm' is not a MyISAM-table
---------
myisamchk: error: 'Factory.frm' is not a MyISAM-table
---------
.
.
.
.