Re: master status is null

Hi All,
I tried both

mysql> show master status;
Empty set (0.00 sec)

mysql> show master status\G
Empty set (0.00 sec)
Can you please let me know what i need to do. Actually, when we loading data using "LOAD DATA" method, the file system became 100% and the slave stop and is giving the below error

070620 6:02:22 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
070620 6:02:22 [ERROR] Got fatal error 1236: 'Binary log is not open' from master when reading data from binary log 070620 6:02:22 [Note] Slave I/O thread exiting, read up to log ' mysql-bin.000153', position 1482416248

Please let me know how i should slove this problem,

thanks a lot for all your help.

regards
anandkl

On 6/20/07, Daniel Donckers <Daniel.Donckers@wal-mart.com> wrote:
>
>
> The problem is probably due to your using both '\G' and ';' to end your
> command statement. You can only use one or the other.
>
> Thanks,
> Daniel J. Donckers
>
> -----Original Message-----
> From: Ananda Kumar [mailto:anandkl@gmail.com]
> Sent: Wednesday, June 20, 2007 9:23 AM
> To: MySQL General
> Subject: master status is null
>
> Hi All,
> We have setup replication. Mysql version 5.0.40. On master db, if i
> execute
> the below command it showing
>
> show master status\G;
>
> Empty set (0.01 sec)
>
> ERROR:
> No query specified
>
> what could be the reason, and how do i fix it. Please help
>
>
>
> regards
>
> anandkl
>
> -----------------------------------------
> *******************************************************************
> *** This email and any files transmitted with it are confidential
> and intended solely for the individual or entity to whom they are
> addressed. If you have received this email in error destroy it
> immediately. ******************************************************
> **************** Wal-Mart Confidential ****************************
> ******************************************
>
>
Received on Wed Jun 20 10:45:21 2007

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek