replace the line to add some text
- by shantanuo
The MySQL dump backup file has the following line...
# head -40 backup20-Apr-2010-07-32.sql | grep 'CHANGE MASTER TO '
-- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000068', MASTER_LOG_POS=176357756;
a) I need to complete the statement with the parameters like Master host, user and password.
b) I do also need to remove the comment "--"
The line should look something like this...
CHANGE MASTER TO MASTER_HOST='111.222.333.444', MASTER_USER='slave_user', MASTER_PASSWORD='slave_user', MASTER_LOG_FILE='mysql-bin.000068', MASTER_LOG_POS=176357756;