Select Code to Download

$ mysqldump --add-drop-table -h host1 db1 | mysql -h host2 db2

# copies the target data without the structure. Creates a
# complete SQL statement including all the field names.
...

# reinserts the data
$ mysql -h host2 db2 < db2.sql

$ ./dbdiff host1 db1 host2 db2
$ ./dbdiff host2 db2 host1 db1

#!/usr/bin/perl -w
use strict;
...

$dbh1->disconnect();
$dbh2->disconnect();

 _  _ _  _  
(_|| | |(_|><
 _|