小弟的debian 5.0主機放置xoops網頁,mysql版本為5.0.51a,最近將xoops網頁移至另一部mysql版本為5.1.49a的主機,每次重啟mysql server就出現如下訊息,網頁也無法正常開啟(將資料庫最佳化或是repair均無效):
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'fZlco_group_permission'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'fZlco_imgset_tplset_link'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'fZlco_modules'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'fZlco_stories'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'fZlco_tplfile'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'fZlco_xoopscomments'; try to repair it
但如果移至另一部mysql版本同為5.0.51a的主機,卻又正常無誤,請各位多指教,感激不盡。
可以的話改用sql檔匯入匯出應該比較OK
不要直接用實體檔案搬移的方式來轉移
5.0轉5.1架構上也算是大改版了