SaRiD
Programmer
- Apr 19, 2003
- 45
Hi
I had mysql replication working fine for awhile until the binary logs used up all the disk space (my bad for not putting anything in place) and all our websites stop working. As a quick fix I deleted one of the first binary logs that where created but left the current binary file that was being loaded from.
Doing that of course stuffed everything up and I haven't been able to get it working since.
I've tried many times stopping/starting the slave, granting new user privilages on the master, changing the master on the slave.
I can access the database if I through the mysql prompt fine, so it shouldn't be a firewall or anything - plus it was working before.
Any thoughts of something else I can try?
Cheers
I had mysql replication working fine for awhile until the binary logs used up all the disk space (my bad for not putting anything in place) and all our websites stop working. As a quick fix I deleted one of the first binary logs that where created but left the current binary file that was being loaded from.
Doing that of course stuffed everything up and I haven't been able to get it working since.
I've tried many times stopping/starting the slave, granting new user privilages on the master, changing the master on the slave.
I can access the database if I through the mysql prompt fine, so it shouldn't be a firewall or anything - plus it was working before.
Any thoughts of something else I can try?
Cheers