Overview
You have identified a corrupted table within your Xinet Venture database as a result of a disk or hardware issue. You attempted to repair the table using the MySQL repair command, however, it fails with output similar to the following:
| webnative.bigwebdata_189 | repair | info | Read error for block at: 2472976588 (error: 5); Skipped |
| webnative.bigwebdata_189 | repair | Error | Error reading file './webnative/bigwebdata_189.MYD' (Errcode: 5 - Input/output error) |
Solution
In situations where the table is irreparable and the table file located within /usr/etc/venture/data/webnative
shows signs of corruption, the file will need to be removed and rebuilt as new.
The dbmgr
utility includes a built-in command that can automatically check the tables and rebuild any missing items.
- Remove the corrupted table file from the filesystem
- You can run the following command from the Terminal:
# sudo rm -rf /usr/etc/venture/data/webnative/<name_of_table>
- For example:
# sudo rm -rf /usr/etc/venture/data/webnative/bigwebdata_189.MYD
- You can run the following command from the Terminal:
- Recreate the removed table
- Run the
dbmgr
utility with the "-fixmissingtables" flag:
# /usr/etc/venture/bin/dbmgr -fixmissingtables
- Note: If you want to route the output of the command to a log file, you can use the following:
# /usr/etc/venture/bin/dbmgr -fixmissingtables &> /var/log/dbmgrlog.log
- Run the
Comments
0 comments
Please sign in to leave a comment.