Hello.


When the replication is configured, the slave is synchronized to a certain

position in the master's binary log. To make this synchronization

often LOAD DATA FROM MASTER is used (but you may fill the slave's

databases in different ways). After a successful setup replication

shouldn't break even after slave or master temporary inaccessibility

and you don't need to upload the data to the slave again.





Lorenzo De Vito <[EMAIL PROTECTED]> wrote:

> I'm setting up a database replication between a master and a slave. Why 

> I need to use command |"LOAD DATA FROM MASTER" ? Can The replication 

> process synchronize data e table structure at startup without launching 

> loading commands ? Once ||synchronized with master the slave need again 

> to be updated in the future using load command ? Thank you

> |

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to