Also, Flush logs on master is not creating any new bin-logs, any specific reason. Now we have close to 19GB free space.
regards anandkl On 6/20/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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 **************************** > ****************************************** > >