We had setup replication and it was working till the file system became 100%
full, after that it stopped.
On 6/21/07, Atle Veka [EMAIL PROTECTED] wrote:
Sounds like Gerald is right, your database server is not configured to
support replication. Have you given your database server a
Sounds like Gerald is right, your database server is not configured to
support replication. Have you given your database server a 'server-id'?
On Wed, 20 Jun 2007, Gerald L. Clark wrote:
Ananda Kumar wrote:
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i
Ananda Kumar wrote:
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)
You do not have replication setup.
ERROR:
No query specified
Use \G or ; but not both.
what could be the
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:
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
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
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,