This is just a temporary article for these notes, I might move them.

Extract all failed tables from the error log with Notepad++

• Get Setup 
  • Download the error log from:

    /var/lib/mysql/server.quantumwarp.com.err

  • Open the log file in Notepad++
• Remove all lines without Table errors
  • Open the Replace dialogue (Ctrl + H)
  • Configure as follows:
    
    • Find what:

      ^(?!.*\[ERROR\] mariadbd: Table).*\r?\n

    • Replace with: nothing
    • Search Mode:
      • Regular expression
      • without `. matches newline`
    • Click Replace All
• Make the lines Uniform
  • Start of the line
    • Open the Replace dialogue (Ctrl + H)
    • Configure as follows:
      
      • Find what:

        .*\[ERROR\] mariadbd: Table '\.

      • Replace with: nothing
      • Search Mode:
        • Regular expression
        • without `. matches newline`
    • Click Replace All
  • End of the line (optional)
    • Open the Replace dialogue (Ctrl + H)
    • Configure as follows:
      
      • Find what:

        ' is marked as crashed and should be repaired$

      • Replace with: nothing
      • Search Mode:
        • Regular expression
        • without `. matches newline`
    • Click Replace All
• Sort the lines
  • Edit --> Line Operations --> Remove Duplicate Lines
  • Edit --> Line Operations --> Sort Lines Lexicographically Ascending