576
576
# Show the result in table test.tstmt on master...
577
577
SELECT * FROM tstmt ORDER BY id;
578
let $diff_table_1=master:test.tstmt;
580
# ... then compare test.tstmt on master to the other tables on master...
581
let $diff_table_2=master:test.tproc;
582
source include/diff_tables.inc;
583
let $diff_table_2=master:test.tfunc;
584
source include/diff_tables.inc;
585
let $diff_table_2=master:test.ttrig;
586
source include/diff_tables.inc;
587
let $diff_table_2=master:test.tprep;
588
source include/diff_tables.inc;
590
# ... and to all tables on slave.
591
sync_slave_with_master;
592
let $diff_table_2=slave:test.tstmt;
593
source include/diff_tables.inc;
594
let $diff_table_2=slave:test.tproc;
595
source include/diff_tables.inc;
596
let $diff_table_2=slave:test.tfunc;
597
source include/diff_tables.inc;
598
let $diff_table_2=slave:test.ttrig;
599
source include/diff_tables.inc;
600
let $diff_table_2=slave:test.tprep;
579
--sync_slave_with_master
581
# ... then compare test.tstmt on master to the other tables on master and slave.
582
let $diff_tables= master:tstmt,tproc,tfunc,ttrig,tprep, slave:tstmt,tproc,tfunc,ttrig,tprep;
601
583
source include/diff_tables.inc;