HOWTO

I recently came across a corrupted table in MySQL and was getting the following error, when I was trying to access a table.

“mysql ERROR 145 (HY000): Table ‘xxxxxxx’ is marked as crashed and should be repaired”

I repaired the table by

• Log into the mysql client using “mysql”
• Change to the required database by using “use DATABASE_NAME”
• Repair the table by using “repair table TABLE_NAME”

Love the simplicity of MySQL :).

If you want to search a file and show all the lines that don’t match a particular pattern, you an use the following option in grep

grep -v "PATTERN" fileName