Re: Replicating server has died

[Rick James]

1. Read the docs.
2. Reread the docs.

Here are some of the issues...
By "drive failure", I assume you have lost all the data on that machine.
And I assume you have never stopped the dead server and dumped the file system. (If you had, there might be a way to load that, then play catchup with replication.)

Probably this is what you have to do:
1. Stop mysql on the good machine.
2. Copy the mysql directory to the new machine.
3. Start mysql on both machines, but be sure replication is turned off on the new one.
4. CHANGE MASTER (on new) to point to the beginning of the binlog that started after step 3.
5. May need some kind of CHANGE MASTER on the good machine.

Caution! Those instructions are approximate.