Inbal, a "snapshot" is simply a backup of the database at a well defined point in time. A snapshot is essential for replication to work. Master and slave are supposed to start with exactly the same set of data ("snapshot") in the beginning.
There are several ways to create a snapshot on the master and copy this snapshot to the slave. If you can afford to take the master server down for a moment, one convenient way to do this is: (After having configured the master and slave for replication, i.e. switching on the binlog etc.) 1. Take the master server down. 2. Copy the database(s) you want to replicate to the <datadir> of the slave server. 3. Restart master and slave. 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: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "Inbal Ovadia" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 12:43 PM Subject: RE: database mirroring in mysql 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