replication-magic number-fire your magician

2001-07-19 Thread Jim Ziegler
my.cnf file on the master contains "log-bin=/var/log/replication.log" but just "log-bin" seems to work. However, how do you control the location and name of the log? (This may just be a documentation issue, but the error message is not very intuitive.) >Submitter-I

Binlog has bad magic number [SOLVED]

2001-07-19 Thread Jim Ziegler
For me, this problem was due to: This problem occurs when the my.cnf file on the master contains "log-bin=/var/log/replication.log" but just "log-bin" seems to work. On Mon, Apr 02, 2001 at 05:11:21PM -0400, Jim Ziegler wrote: > What causes: > > 010402 17:08:

Re: bad magic number, fire your magician error

2001-06-26 Thread Jim Ziegler
.143' at position 20054 > > > Again, any help you can provide will be immensely appreciated. Thanks for > you time and have a great day. > > Sincerely, > > Patrick Ward > Jr Programmer/DB Administrator. >

Re: how to install mysql replication ?

2001-06-12 Thread Jim Ziegler
On Tue, Jun 12, 2001 at 12:45:15PM -0700, Jeremy Zawodny wrote: > On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote: > > On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: > > > On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: > > &

Re: how to install mysql replication ?

2001-06-12 Thread Jim Ziegler
fore 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]>

replication problems

2001-04-13 Thread Jim Ziegler
does anyone that is using replication have any suggestions at all about how to get past this problem? is anyone using replication successfully? - Forwarded message from Jim Ziegler <[EMAIL PROTECTED]> - Envelope-to: [EMAIL PROTECTED] Delivery-date: Tue, 10 Apr 2001 16:42:26

replication problems

2001-04-10 Thread Jim Ziegler
_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum What is wrong? Where do I get a better magic

Re: Binlog has bad magic number

2001-04-09 Thread Jim Ziegler
to do with the replication resumed in log 'FIRST' message? The log file on the master is not named FIRST. -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the man

SOLVED: Re: load aca from master

2001-04-09 Thread Jim Ziegler
On Mon, Apr 09, 2001 at 02:01:55PM -0400, Jim Ziegler wrote: > > > > database,sql,query > > > > load table from master > does not work for me. I get the error message > ERROR 1189: Net error reading from master > what can cause this? > both

Re: load aca from master

2001-04-09 Thread Jim Ziegler
> > database,sql,query > load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log -- [EMAIL PROTECTED] (Ji

Binlog has bad magic number

2001-04-02 Thread Jim Ziegler
:34 fetch_nx_table: failed on create table when i try to: mysql> load table aca from master; ERROR 1189: Net error reading from master -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.

problem with "LOAD TABLE" command

2001-04-02 Thread Jim Ziegler
queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.034 ------ -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li