Compare MySQL tables and rows between databases.
基于MySQL的数据库差异比对工具,支持表结构、数据行的差异比较,导出标准的SQL文件。
usage: dbff [-h] [--source-host HOST] [--source-port PORT]
[--source-username USERNAME] [--source-password PASSWORD]
[--source-schema SCHEMA] [--target-host HOST] [--target-port PORT]
[--target-username USERNAME] [--target-password PASSWORD]
[--target-schema SCHEMA] [-d] [--whitelist TABLES]
[--blacklist TABLES] [--default-character-set CHARSET_NAME]
[--log-error FILE] [-O FILE] [-v] [--version]
loris database comparer v1.4.0
optional arguments:
-h, --help show this help message and exit
--source-host HOST
--source-port PORT
--source-username USERNAME
--source-password PASSWORD
--source-schema SCHEMA
--target-host HOST
--target-port PORT
--target-username USERNAME
--target-password PASSWORD
--target-schema SCHEMA
-d, --no-data do not write any table row information.
--whitelist TABLES specify tables that will be included
--blacklist TABLES specify tables that will be excluded
--default-character-set CHARSET_NAME
set the default character set
--log-error FILE append warnings and errors to given file
-O FILE, --output-document FILE
output file name
-v, --verbose print extra information
--version output version information and exit
Report bugs to: [email protected]
e.g.
bin/dbff --source-host=192.168.1.6 --source-port=3306 --source-username=root --source-password=123456 --source-schema=mysql \
--target-host=192.168.1.8 --target-port=3306 --target-username=root --target-password=123456 --target-schema=mysql \
-O/tmp/mysql_6-8.sql -t16
If you want to develop with dbff, just install from pypi: sudo pip install dbff
and if you get the following error report related to the mysql_config command:
sh: mysql_config: command not found
install the mysql package first:
sudo apt-get install mysql
or
sudo brew install mysql
Good luck :)