Page 1 of 1

[solved] SHOW MASTER STATUS; This doesnt work

Posted: Thu Jan 26, 2006 11:06 am
by mhouldridge
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