search

swrd / check-mysql-all

Automatically exported from code.google.com/p/check-mysql-all
0 stars 0 forks source link

Mysql-View-Tables #11

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. mysql_check_all tables
2. create a mysql view
3. get warning of corrupted view

What is the expected output? What do you see instead?
the view tables are not corrupted

What version of the product are you using? On what operating system?
latest from download section

Please provide any additional information below.

Original issue reported on code.google.com by mirco.he...@googlemail.com on 19 Oct 2010 at 8:17

GoogleCodeExporter commented 8 years ago 
I am not a Perl-Code but this worked, in Line 562 change the code to:

            if(/VIEW/) {
            }
            else {
            if (/marked as crashed/) {
                push(@errs, "$db.$table marked as crashed");
            } elsif (/(err(?:code|no):\s\d+)/i) {
                push(@errs, "$db.$table has an error ($1)");
            } elsif (! defined($tables_status->{$db}{$table}{'Rows'})) {
                push(@errs, "$db.$table is corrupted");
            }
            }

Original comment by mirco.he...@googlemail.com on 31 Oct 2010 at 1:16

GoogleCodeExporter commented 8 years ago

Original comment by ryan.a.l...@gmail.com on 18 Nov 2010 at 11:31

GoogleCodeExporter commented 8 years ago

Original comment by ryan.a.l...@gmail.com on 8 Feb 2011 at 11:14