Hi, I am new to MySQL. I am not sure how to set timezones. But your slave status and slave processlist doesn't show any problem. It replicated correctly and wait for I/O thread to update the relay log.
use '\G' instead of ';' Saravanan --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote: > From: Paul Berry <[EMAIL PROTECTED]> > Subject: Re: another slave loading question > To: [EMAIL PROTECTED], "MySql" <mysql@lists.mysql.com> > Date: Saturday, January 19, 2008, 8:16 AM > hi thanks for the quick answer ! these 2 servers are in > different timezones > - do i need to set the slave server to the master > slave's timezone? > > i'm giong to research implementing that right away - in > the meantime i > thought this might help show some information > > i have this on the master: > > mysql> show master status; > +----------------+----------+--------------+------------------+ > | File | Position | Binlog_Do_DB | > Binlog_Ignore_DB | > +----------------+----------+--------------+------------------+ > | dp3-bin.000002 | 5382028 | ***** | | > +----------------+----------+--------------+------------------+ > 1 row in set (0.00 sec) > > > and this on the slave: > > mysql> show slave status; > +----------------+--------------+-------------+-------------+---------------+-----------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+ > | Slave_IO_State | Master_Host | Master_User | Master_Port > | Connect_Retry > | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File > | > Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | > Slave_SQL_Running > | Replicate_Do_DB | Replicate_Ignore_DB | > Replicate_Do_Table | > Replicate_Ignore_Table | Replicate_Wild_Do_Table | > Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | > Skip_Counter | > Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | > Until_Log_File | > Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | > Master_SSL_CA_Path > | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | > Seconds_Behind_Master | > +----------------+--------------+-------------+-------------+---------------+-----------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+ > | | ***** | ***** | 13306 | > 60 | > dp3-bin.000002 | 4126670 | > *****-sql-relay-bin.000002| > 233 | > dp3-bin.000002 | No | Yes > | ***** > ; | | > | | > | | 0 | | > 0 > | 4126670 | 233 | None | > | 0 | No | > | | | > | > | | > +----------------+--------------+-------------+-------------+---------------+-----------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+ > 1 row in set (0.00 sec) > > > > > > On 1/18/08, Saravanan <[EMAIL PROTECTED]> wrote: > > > > 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 > > ____________________________________________________________________________________ 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]
