| Bug #46 | mysqlcheck bug in autorepair mode | ||
|---|---|---|---|
| Submitted: | 28 Jan 2003 14:26 | Modified: | 8 Feb 2003 2:47 |
| Reporter: | Peter Zaitsev (Basic Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S3 (Non-critical) |
| Version: | 4.0 and 3.23 | OS: | Any (all) |
| Assigned to: | Jani Tolonen | CPU Architecture: | Any |
[8 Feb 2003 2:47]
Matt Wagner
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ Fixed in 4.0.11
Description: 1) --auto-repair does not work if -c is not specified, while check seems to be default option for other purposes. This gave me a lot of of hassle finding it out. 2) --auto-repair does not work at all :) It runs REPAIR TABLE `database.table` which is parsed as a table name only and returned "Invalid table name error" Here is the log snip: # tail /usr/local/var/prddbs03.log 2 Query CHECK TABLE `airline_destinations` 2 Query CHECK TABLE `airline_status` 2 Query CHECK TABLE `airlines` 2 Query CHECK TABLE `airlines_LM2` 2 Query CHECK TABLE `airlines_LM6` 2 Query CHECK TABLE `airlines_TP2` 2 Query CHECK TABLE `airlines_TP4` 2 Query CHECK TABLE `daily_da_airline_count` 2 Query REPAIR TABLE `Airlines.access_log` Notice table name is escaped together with database name. How to repeat: 1) create corrupted table in database test 2) run mysqlcheck -c --auto-repair -A Suggested fix: Workaround to use --all-in-1 option which does proper table name escaping.