I have slightly modified automysqlbackup to include the dump_slave option that was included in 5.5.3
I added the following variable: CONFIG_mysql_dump_slave_data=
and then below the master_data block I added this: [] && (( ${CONFIG_mysql_dump_slave_data} == 1 || ${CONFIG_mysql_dump_slave_data} == 2 )) && { opt=( "${opt}" "-dump-slave=${CONFIG_mysql_dump_slave_data}" "-include-master-host-port");} [] && { opt=( "${opt}" '-single-transaction' ) opt_fullschema=( "${opt_fullschema}" '-single-transaction' ) }
This works like a champ for me on the current release of mysql. Follow the same rules as you would for master-data.
Allen
Log in to post a comment.
I have slightly modified automysqlbackup to include the dump_slave option that was included in 5.5.3
I added the following variable:
CONFIG_mysql_dump_slave_data=
and then below the master_data block I added this:
[] && (( ${CONFIG_mysql_dump_slave_data} == 1 || ${CONFIG_mysql_dump_slave_data} == 2 )) && { opt=( "${opt}" "-dump-slave=${CONFIG_mysql_dump_slave_data}" "-include-master-host-port");}
[] && {
opt=( "${opt}" '-single-transaction' )
opt_fullschema=( "${opt_fullschema}" '-single-transaction' )
}
This works like a champ for me on the current release of mysql. Follow the same rules as you would for master-data.
Allen