Hi,
in short what we did was the following:
- binary logs was written to a 20GB filesystem and due to company
policies we kept expire logs at 7 days.
- system got quite busy over the years so the space was becoming a
problem and thus we had to move to another directory.
-
What setting(s) did you change to move to the separate partition?
SHOW VARIABLES LIKE '%bin%';
SHOW VARIABLES LIKE '%dir%';
(there may be other VARIABLES worth checking)
What steps did you take for the move? (Actually move bin.1? Start over? etc?)
Consider using expire_logs_days.
5.0
issue on the slave:
SHOW SLAVE STATUS\G and post here
most likely after you reset the master your slave can't synch anymore,
because its missing next sequence of replication file.
why don't you backup your master with mysqldump and re-issue it ont he new
setup (i.e. on MySQL 5.5 instance)?
