#!/bin/bash
# Usage: ./bug28616.sh /path/to/mysql

export MYSQL_HOME=$1
mkdir /tmp/master
mkdir /tmp/slave
chown -R mysql:mysql /tmp/master
chown -R mysql:mysql /tmp/slave
cd $MYSQL_HOME
./scripts/mysql_install_db --user=mysql --datadir=/tmp/master
./scripts/mysql_install_db --user=mysql --datadir=/tmp/slave
./bin/mysqld --user=mysql --datadir=/tmp/master/ --socket=/tmp/master/mysqld.sock --port=3370 --log-bin=/tmp/master/binlog --server-id=1 --log-err=/tmp/master/master.err &
./bin/mysqld --user=mysql --datadir=/tmp/slave/ --socket=/tmp/slave/mysqld.sock --port=3371 --replicate-ignore-table=some.nonexistant_table --server-id=2 --log-err=/tmp/slave/slave.err &
sleep 20
./bin/mysql -S /tmp/master/mysqld.sock -e "GRANT ALL PRIVILEGES ON *.* TO 'repl'@'localhost' IDENTIFIED BY 'repl'"
./bin/mysql -S /tmp/slave/mysqld.sock -e "CHANGE MASTER TO master_host='127.0.0.1', master_port=3370, master_user='repl', master_password='repl', master_log_file='binlog.000001', master_log_pos=4"
./bin/mysql -S /tmp/slave/mysqld.sock -e "SLAVE START"
echo "Now run bug28616.sql on master and watch slave"