Script to check and take crashed database list in a file

mysqlcheck –all-databases | grep “doesn’t exist” | awk {‘print $4′} | cut -d. -f1 | cut -d \’ -f2 | uniq > /root/dblist

Leave a comment