Wednesday, April 13, 2011

Fix Corrupt relay logs

Master_Log_File: The name of the master binary log file from which the I/O thread is currently reading.
Relay_Log_File: The name of the relay log file from which the SQL thread is currently reading and executing.

Relay_Master_Log_File: The name of the master binary log file containing the most recent event executed by the SQL thread.


-- The status below is most often cause by network connection between slave and master being dropped while slave while slave is reading master's binary log to create the relay log.
-- The "Last_error:" message states that it could be master binary or slave relay log corruption. It is usually slave relay corruption because it is much easier to corrupt this log.

Friday, April 1, 2011

mysql dump over ssh

mysqldump -uroot -p epictide events quartz | gzip -c | ssh michaelfw@128.147.97.132 'cat > ~/dump.sql.gz'