:::
XOOPS使用討論區

mysql資料庫錯誤訊息

discuss pic 2011-08-19 09:31:45
小弟的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的主機,卻又正常無誤,請各位多指教,感激不盡。
discuss pic 2011-08-22 01:02:53
tad
可以的話改用sql檔匯入匯出應該比較OK
不要直接用實體檔案搬移的方式來轉移
5.0轉5.1架構上也算是大改版了
:::

搜尋

QR Code 區塊

https%3A%2F%2Fwww.tad0616.net%2Fmodules%2Ftad_discuss%2Fdiscuss.php%3FDiscussID%3D2043%26BoardID%3D17

線上使用者

50人線上 (30人在瀏覽討論留言)

會員: 0

訪客: 50

更多…