Perform a binary search in a large number of MySQL database dumps

pip install mysqlbisect==1.1



This is a tool for searching for a change in a huge folder of SQL dumps that is non-trivial to detect without full SQL functionality.

Usage: mysqlbisect [OPTIONS] [FILENAME]...

  Takes a number of SQL dumps, imports them into a temporary database and
  runs a query on them. Then it performs a binary search on them to find the
  EARLIEST dump where the query returns a result. The SQL dumps are
  processed in alphabetical filename order. If a query returns a row
  consisting only of 0 and NULL, it will be counted as "no result".

  -h, --host TEXT      MySQL host to use for temporary databases
  -u, --user TEXT      MySQL user to use for temporary databases. Needs
                       permission to create and drop databases of the name
                       specified with --db.
  -p, --password TEXT  MySQL user password
  --db TEXT            MySQL database name scheme for temporary database.
                       Default: bisect_tmp
  -q, --query TEXT     MySQL query to check in each file.  [required]
  -v, --verbose        Verbose output.
  --help               Show this message and exit.


Copyright 2016 Raphael Michel

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.