fix mysql relay log

• SHOW SLAVE STATUS //note relay_master_log_pos and exec_master_log_pos
• SLAVE STOP
• CHANGE MASTER TO MASTER_LOG_FILE=[relay_master_log_pos value], MASTER_LOG_POS=[exec_master_log_pos]
• SLAVE START

mysql command line client prompt

I usually like to change the default mysql client prompt to user@hostname:dbname >. Open my.cnf and replace prompt = “” with

prompt = “\u@\h:\d >”

mysql command line autocomplete rescan/enable

mysql>\#

Impossible WHERE noticed after reading const tables

MySQL has read all const (and system) tables and notice that the WHERE clause is always false.