view release on metacpan or  search on metacpan

bin/dbix_replicate  view on Meta::CPAN

  --copy-by=cols      copy by block of rows with same values in ``colums''
  --primary-key=cols  primary key columns
  --columns=cols      list of column names (required if using --primary-key)
  --block=num_rows    number of rows to be copied at once (same as above)
  --extra-cond=expr   SQL expression for filtering rows to be copied

Examples:

  # copy using DBIx::Replicate::Strategy::CopyBy
  $0 \
    --src='dbi:mysql:test;table=t;host=db1;user=root;mysql_enable_utf8=1' \
    --dest='dbi:mysql:test;table=t;host=db2;user=root;mysql_enable_utf8=1' \
    --copy-by='id,subid'

  # copy using DBIx::Replicate::Strategy::PK
  $0 \
    --src='dbi:mysql:test;table=t;host=db1;user=root;mysql_enable_utf8=1' \
    --dest='dbi:mysql:test;table=t;host=db2;user=root;mysql_enable_utf8=1' \
    --primary-key='id' \
    --columns='subid,name,flags'

EOT
;
    exit 0;
}

sub connect_to_db {
    my $addr = shift;