an Irvine [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2008 2:11 PM
> To: Mike
> Cc: mysql@lists.mysql.com
> Subject: Re: slave io status: no wont' change
>
> here's the master status from the master;
>
> mysql> show master status;
> +-
ake a fresh mysqldump with the --master-data
> parameter and refresh the slave, run the 'change master' statement at
> the top of the backup and it should start.
>
> -Original Message-
> From: Bryan Irvine [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 200
t at
the top of the backup and it should start.
-Original Message-
From: Bryan Irvine [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2008 2:11 PM
To: Mike
Cc: mysql@lists.mysql.com
Subject: Re: slave io status: no wont' change
here's the master
here's the master status from the master;
mysql> show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
| mysql-bin.23 | 98 |
Do you have the original mysql> show slave status\G; off the master?
I have a feeling you have the position wrong. I about 100% sure you have
the position wrong because it happened to me.
if you don't have it do a show slave status\G; and try to remember which one
you took.
Mike
On Mon, Jul 28
Mike,
Yes take a peek here:
mysql> show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
| mysql-bin.45 | 98 | exampledb
Did you start from position Exec_Master_Log_Pos 1? Can you tell us the
command you used to get this going?
Mike
On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine <[EMAIL PROTECTED]> wrote:
> I'm having an issue setting up a slave Where it doesn't seem to start:
>
> mysql> show master status;
> +---
