Hi and thanks for the reply. After I read all about replication, I have a little question. In section 4.10.3 How To Set Up Replication, in step 3 it is written "and then take a snapshot of the data on your master server". I am working on windows 2000 and I don't understand, how do I do the snapshot??? And another thing. Before I am doing all this steps, do I need to create the slave database? where do I need to create it?
Thanks -----Original Message----- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:29 AM To: Inbal Ovadia; [EMAIL PROTECTED] Subject: Re: database mirroring in mysql Inbal, > Is there a possibility, in MySql, to define a "mirror" to my database, Yes. In MySQL, it's called "replication", and it's quite easy to setup. More info: http://www.mysql.com/doc/en/Replication.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Inbal Ovadia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 02, 2003 4:56 PM Subject: database mirroring in mysql > Hi all, > Is there a possibility, in MySql, to define a "mirror" to my database, > meaning that I define another database that will be a copy of my database > and every operation that I will make on my database, will be done > automatically in the second database? > > Or if I define database that contain only part of the tables in my database > and when I will do some operations on one of those tables, the operations > will be done in the second database? > > Thanks, Inbal > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php