Van wrote:
>
> Van wrote:
> >
> > This one's great:
> > /usr/local/libexec/mysqld: ready for connections
> > 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication
> > started in log 'FIRST' at position 4
> > 010319 1:51:41 Error reading packet from server: Binlog has bad magic number,
> > fire your magician (read_errno 0,server_errno=65535)
> > 010319 1:51:41 Slave: Failed reading log event, reconnecting to retry, log
> > 'FIRST' position 4
> > 010319 1:51:41 Slave: reconnected to master 'pima@scottsdale:3306',replication
> > resumed in log 'FIRST' at position 4
> > 010319 1:51:41 Error reading packet from server: Binlog has bad magic number,
> > fire your magician (read_errno 0,server_errno=65535)
> >
> > Any thoughts would, obviously, be quite useful?
> >
> > BTW: The magician is me. So, how do I pink-slip myself? >:)
> >
> > Best Regards,
> > Van
> Again:
> 010319 1:31:38 Aborted connection 13 to db: 'btime' user: 'vanboers' host:
> `localhost' (Got an error reading communication packets)
> 010319 1:59:44 Aborted connection 9 to db: 'adams' user: 'jobseek' host:
> `localhost' (Got an error reading communication packets)
> 010319 2:00:26 Aborted connection 87 to db: 'btime' user: 'vanboers' host:
> `localhost' (Got an error reading communication packets)
> 010319 2:01:27 Aborted connection 5 to db: 'btime' user: 'vanboers' host:
> `localhost' (Got an error reading communication packets)
> 010319 2:29:09 Aborted connection 71 to db: 'btime' user: 'vanboers' host:
> `localhost' (Got an error reading communication packets)
> 010319 2:29:36 Aborted connection 61 to db: 'adams' user: 'jobseek' host:
> `localhost' (Got an error reading communication packets)
> 010319 2:29:39 Aborted connection 120 to db: 'adams' user: 'jobseek' host:
> `localhost' (Got an error reading communication packets)
> 010319 2:36:23 Aborted connection 54 to db: 'btime' user: 'vanboers' host:
> `localhost' (Got an error reading communication packets)
>
> The worst part? All data updates are going through. What the samhell's goin'
> on?
>
> Van
>
The compiler that made this db was egcs-2.91. Upgraded to 2.95.2, and did the
following:
Master:
mysqladmin shutdown
rm /mysql/*-bin.log /mysql/-bin.index
tar czvf /backup/mysql.tgz /mysql/
Slave:
cd /mysql
rm -Rf /mysql/*
ncftp master
cd /backup
get mysql.tgz
by
cd /
tar xzvf /mysql/mysql.tgz && rm /mysql/mysql.tgz
rm /mysql/*.tgz /mysql/master*.* /mysql/master.index
Master:
/etc/rc.d/rc.mysql
Slave:
/etc/rc.d/rc.mysql
*Note: In the above master refers to the master hostname except for the
reference to master.index.
They're replicating, now.
Van
--
=========================================================================
Linux rocks!!! http://www.dedserius.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
