-----Original Message-----
From: Ravi T
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:49 AM
Subject: Is there any good soul out there who can help me with mysql 4.0.17
replication.
Hi,
I am new to mysql and having some trouble with replication. Simple
stuff like,
1. How to restart the stopped resplication,
On the slave:
SHOW SLAVE STATUSL
Fix the error found in the `Last_error` column
2. How to check if the replication is working,
SHOW SLAVE STATUS
Both `Slave_IO_Running` and `Slave_SQL_Running` should be `Yes`
3. How to bring the slave into master status when master crashes,
The slave needs to be set up to log-bin
The change master on the other slaves to point to this new master
4. How to restore master and re-enable replication.
Rebuild the tables on the master and sync up the slaves
Thanks and appreciate very much if some one could donate the time and
help.
Ravi T.
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
