[solved] SHOW MASTER STATUS; This doesnt work

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

[solved] SHOW MASTER STATUS; This doesnt work

Post 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
Post Reply