That would be a great way to keep your website up to date. The slave can handle loss of connection (though some data may not make sense if part of it is missing), and resume where it has left of previously. Or you could also manually start and stop the slave process when you know there is a live connection.
As long as you are not modifying the slave database, that could cause problems. Some people have successfully looped thier replication process (A->B, B->A), which I know nothing about. I am assuming you want to have the hosting companies server replicate from your local copy of the database? If that is the case, starting and stopping the slave process is not really an option (unless you have your own install of mysql). And of course if you do not have a static IP address it would be a real pain in the behind ( since your hosting company will probably be the one changing the slave access, unless of course you have your own install ) Good luck Luc > -----Original Message----- > From: Alexander Shaw [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 28, 2002 5:47 AM > To: MySQL List > Subject: Replication question > > > Hi > > Is it feasible to use replication to keep the database which powers my > website up-to-date? The database itself is on the hosting > companies server > and contacted via dialup so the connection isn't there all of > the time. > Naturally I keep a copy of the database on my local machine too. > > Alex > > Alexander Shaw > Agricultural Stock and Assignment Photography > www.Agri-Image.com > > sql query --------------------------------------------------------------------- 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