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
[solved] SHOW MASTER STATUS; This doesnt work
Moderator: General Moderators
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am