Loss of connection should not break replication. It will stop it, but once you're connected again it should pick right back up where it left off.
To restore you can either dump the entire database from the master and load into the slave, then use "CHANGE MASTER TO" to set up the slave. We usually use LVM snapshots combined with rsync. On Fri, Dec 5, 2008 at 7:02 AM, Marcel Grandemange <[EMAIL PROTECTED] > wrote: > Good Day. > > Im wondering if someone can assist me. > > Ive been using replication for a while now and it tends to fail very > easily. > > One of my sites lost connectivity for a while and when it came back > obviously replication broke again. > > How can I get it to populate all data from master again? > > Load data from master; is being depreciated and doesn't really work anyhow. > I do not wish to create dump and do this manually every time it fails. > > > Advise? > > Also is replication really this unreliable? It breaks at the slightest > hiccup... > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
