Hi thanks a lot for your prompt reply. The second email went out on accident - apologies.
I managed to fix it - I found "localhost; EcolMod1" in user.myd. Thanks again, Rainer On 13 Nov 2003 at 10:41, nm wrote: > > Hi there > > I have a question regarding replication. > This is the situation: > > Mysql-Max4.0.16 > > 192.168.0.10 master > 192.168.0.11 slave > > I would like to use the slave as the backup server > and use it in case the master goes down for any reason. > > I'm looking for a safe method to re-update the master when we take it > up again. I read that 2-ways replication is dangerous so for peace of > mind I would avoid it. > > I was considering a simple dump of the database on slave, > when I have to reconnect the master server. > > I would: > > 1. disconnect the slave > 2. create a dump file form salve > 3. put the dump on the master > 4. reconnect the master and slave > > Questions are.. > > a. I use innodb tables. Any problems to nofify? > b. Are auto_increment values correct/safe after such operations. I > guess so but I'm not 100% sure c. Do you have comments and suggestions > regarding 2-ways replications > > > Any suggestion / comment is welcome ;) > > Thanks!! > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- Rainer M. Krug, Dipl. Phys. (Germany), MSc Conservation Biology (UCT) Department of Conservation Ecology University of Stellenbosch Matieland 7602 South Africa Tel: +27 - (0)21 882 8862 Fax: +27 - (0)21 808 3304 Cell: +27 - (0)83 9479 042 email: [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]