Hi If the databases are not too big, and are on the same machine, you could just copy the directory with the databases in.
If you need to restore the database just copy it back. I think this is OK, though you might want to stop mysql to "lock" the database. I have only done this a couple of times (on a quiet database) because I replicate across two servers. If anybody knows better, or thinks this is a bad idea, then I will defer to their greater knowledge! HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Luc Foisy [mailto:[EMAIL PROTECTED]] > Sent: 06 May 2002 18:33 > To: MYSQL-List (E-mail) > Subject: Two database servers, same physical server > > > > Has someone done this before? What things do I have to take into > consideration > > The following are things I know that may be issues > reading mysql.sock > reading my.cnf > database directory ( there is a parameter for command line operation ) > I would suppose I would have to create a dual instance of the > daemon script > > Anything else I might be missing? > What should I do to make this work? > > ------------------- > > Why do I want to do this? Replication. One slave can not be slave to > mulitple masters. ( as far as I know ). I do not want to have a so many > servers as I have clients ( the replication is a saftey thing > offered by us, > most clients still have thier own replication server, but some > just can not > afford it, so we replicate for them. ) > Now that I have written the above "R" word, this mail will be completely > ignored. Why is that? I have yet to see answers to any questions > in regards > to replication. Is it that nobody else uses replication except the people > who have problems, or just that no person has extended knowlegde on the > issue and they just keep their mouths shut so they don't lead > others astray. > Just curious. > > --------------------------------------------------------------------- > 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
