Have you read the manual, and the user-contributed comments?
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
Ananda Kumar wrote:
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 ****************************
> ******************************************
>
>
--
Baron Schwartz
http://www.xaprb.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
