Mine

my $name_of_table = "jos_banner";
my $table_struct_cmp_data = "-- Table structure for table `$name_of_table`";

while(<$fh>) {
    chomp;
    $linenumber++;
    if ( $_ eq $db_cmp_data ) {
        $begin_of_db = $linenumber;
        next;
    }
    if ( /.*Current Database.*/ ) {
        $end_of_db = $linenumber;
        last;
    }
}
close $fh;