| Bugzilla is a web-based bug tracking and testing | | | | # myisamchk /var/lib/mysql/bugs/*.MYI >> /tmp |
| application that is used by many software | | | | myisamchk_log.txt |
| development companies. It extensively various | | | | The /tmp/myisamchk_log.txt file will contain the |
| databases including MySQL for its backend | | | | list of all the checked tables as displayed: |
| support especially because both of these | | | | Checking MyISAM file: user_group_map.MYI |
| applications are freely available. Although this tool | | | | Data records: 182 Deleted blocks: 0 |
| runs pretty fine in most cases, it can get stalled | | | | - check file-size |
| when the some of the MySQL tables get corrupt. | | | | - check record delete-chain |
| In such cases, you are unable to perform various | | | | - check key delete-chain |
| tasks on the database. You can use the | | | | - check index reference |
| 'myisamchk' command with different parameters | | | | - check data record references index: 1 |
| to repair MySQL database. If it does not work, | | | | Repair the table using the following command: |
| then you should use a professional MySQL | | | | # myisamchk -r profiles.MYI |
| recovery software to recover MySQL database. | | | | You should do a check and repair using the |
| Discussing a similar situation in Bugzilla, consider | | | | myisamchk command as displayed: |
| you get the following error message while | | | | # myisamchk --silent --force --fast --update-state |
| generating a bugs report: | | | | /var/lib/mysql/bugs/*.MYI |
| "undef error - DBD::mysql::db selectrow_array | | | | The 'myisamchk' tool is competent enough to |
| failed: Table 'attach_data' ismarked as crashed | | | | check and repair the MyISAM table. But some |
| and should be repaired [for Statement "SELECT | | | | instances have been noticed where the table is |
| LENGTH(thedata) | | | | not repaired using this tool. On such occasions, the |
| FROM attach_data WHERE id =?"] at Bugzilla | | | | most worthwhile option is to use a third-party |
| Attachment.pm line 344 | | | | software to perform MySQL repair. These |
| ASH(0x9df119c)') called" | | | | MySQL recovery tools guarantee MySQL repair |
| Cause: | | | | without any damage to the original tables. |
| As can be inferred from the message itself, the | | | | One such software is Stellar Phoenix Database |
| 'attach_data' table is corrupt, which is why you | | | | Recovery for MySQL, which repairs MySQL files |
| are getting this error message in Bugzilla. | | | | from all instances of logical corruption. Can be |
| Resolution: | | | | used on various Windows platforms including |
| To resolve this error message and repair MySQL | | | | Windows 7, Vista, Server 2003, XP, and 2000, |
| database, you should perform the following steps: | | | | this MySQL recovery utility recovers MySQL |
| You should find out all the corrupt tables in the | | | | tables created in MySQL 3.x, 4.x, 5.x, and 6.x |
| MyISAM database using the following command: | | | | versions. |