On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote:
> I have two machines which I am trying to set up replication on. I followed
> the howto as describe in the manual, and everything seemed to be okay (i.e.
> no errors), but it simply doesn't work.
>
> Heres what I did on the master:
> 1. Copied /usr/share/my-large.cnf to /etc/my.cnf
> 2. my.cnf already had log-bin, server-id=1, so I didnt touch anything else
> 3. Granted file to user repl as in howto
> 4. Shut down master
> 5. Tarred data dir, copied it to slave
> 6. Restarted master
>
> Heres what I did on the slave:
> 1. Copied /usr/share/my-large.cnf to /etc/my.cnf
> 2. Added following info:
> master-host = 172.34.123.34 # IP of master
> master-user = repl
> master-password = repl
> master-port = 3306
> server-id = 2
> 3. Untarred data directories to /var/lib/mysql
> 4. Verified permissions on directories/files untarred
> 5. Restarted slave
>
> The my.cnf file appears to be read okay, because on both machines began
> generating the binary log files immediately.
>
> Both machines report everything normal and happy, with no entries in the
> .err log files. Users can connect to each machine independently and its
> business as usual.
>
> There is no file 'master.info' generated on the slave (I even checked on the
> master too)...
That's sort of strange...
Does "SHOW SLAVE STATUS" on the slave say anything interesting?
What if you do a "SLAVE START" on the slave?
You're sure that there is literally nothing related in the *.err file
on the slave?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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