did you check time in master and slave servers?
saravanan
--- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote:
> From: Paul Berry <[EMAIL PROTECTED]>
> Subject: another slave loading question
> To: "MySql" <mysql@lists.mysql.com>
> Date: Saturday, January 19, 2008, 7:56 AM
> i have this State when I start a slave: Has read all relay
> log; waiting for
> the slave I/O thread to update it
>
> mysql> show processlist;
> +----+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------+------------------+
> | Id | User | Host | db | Command | Time |
> State
> |
> Info |
> +----+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------+------------------+
> | 17 | root | localhost | **** | Query | 0 |
> NULL
> | show
> processlist |
> | 23 | system user | | NULL | Connect | 2057
> | Has read all
> relay log; waiting for the slave I/O thread to update it |
> NULL
> |
> +----+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------+------------------+
> 2 rows in set (0.00 sec)
>
>
> it was started with a mysqldump and is now many hours
> behind the master
> it seems from what i've researched that its now off on
> the start points and
> so it won't ever get through it
> can i LOAD DATA FROM MASTER; to have it clean up, or is
> there a method or
> something i'm missing
> thanks!
> paul
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
