Don't understand it still It doesn't give me errors in logfile orf when I type show server stutus. Yet it isn't replicating !! Any ideas ? I even tryed checking file sizes between servers on the .MYD file and it isn't working
Mozzi Dicky Wahyu Purnomo wrote: > Pada Mon, 02 Sep 2002 12:51:50 +0200 > Mozzi <[EMAIL PROTECTED]> menulis : > > >>Heya Dicky >>How are you ? Havn't seen you in a while ;-) >> >>kay what I did was >> >RESET MASTER and RESET SLAVE >>And restartted slave >>That worked!!! >> >>Now what I want to know is when I give the command >show slave status I >>get the following >>mysql> show slave status; >>+---------------+-------------+-------------+---------------+-------------------+---------+---------------+-----------------+---------------------+------------+------------+--------------+ >>| Master_Host | Master_User | Master_Port | Connect_retry | Log_File >> | Pos | Slave_Running | Replicate_do_db | >>Replicate_ignore_db | Last_errno | Last_error | Skip_counter | >>+---------------+-------------+-------------+---------------+-------------------+---------+---------------+-----------------+---------------------+------------+------------+--------------+ >>| 196.25.84.193 | replicate | 3306 | 60 | >>ais-rad02-bin.001 | 2575635 | Yes | | >> | 0 | | 0 | >>+---------------+-------------+-------------+---------------+-------------------+---------+---------------+-----------------+---------------------+------------+------------+--------------+ >>1 row in set (0.01 sec) >> >>Is it actually replicating ? >>my my.cnf files look like this >>SLAVE---> >>[mysqld] >> socket=/var/lib/mysql/mysql.sock >> server-id=2 >> master-host=<myip> >> master-user=<user> >> master-password=<passwd> >> replicate-do-table=radius.radcheck >> replicate-do-table=radius.usergroup >> >> log=/var/log/mysqld.log >>---<end>---- >> >>MASTER------> >>[mysqld] >>socket=/var/lib/mysql/mysql.sock >>server-id=1 >> >>log=/var/log/mysqld.log >>log-bin >>----<end>---- >> >>How long does it take normally ? > > > normal to me :D > > usually i use binlog-do-db=.... and replicate-do-db=.... that's why i found your >slave status is a little not "normal" to me :D > > as long as what you need is working, then everything is ok ;-) > > -- > Let's call it an accidental feature. > -- Larry Wall > > MySQL 3.23.51 : up 73 days, Queries : 357.245 per second (avg). > > -- > Dicky Wahyu Purnomo - System Administrator > PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 > Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com > --------------------------------------------------------------------- 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
