[solved] SHOW MASTER STATUS; This doesnt work
Posted: Thu Jan 26, 2006 11:06 am
Hi,
I am trying to find out the log position number for my database in order to set up replication.
I have tried,
mysql>show status
This gives me a number of results. I need to find the master log and log position.
Any ideas?
Here is the code I need to input into the console;
CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user', MASTER_PASSWORD='<some_password>', MASTER_LOG_FILE='mysql-bin.006', MASTER_LOG_POS=183;
The last two I do not know what to input.
Please help
I am trying to find out the log position number for my database in order to set up replication.
I have tried,
mysql>show status
This gives me a number of results. I need to find the master log and log position.
Any ideas?
Here is the code I need to input into the console;
CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user', MASTER_PASSWORD='<some_password>', MASTER_LOG_FILE='mysql-bin.006', MASTER_LOG_POS=183;
The last two I do not know what to input.
Please help