Mysql Cheatsheet

1. Check mysql running queries

mysql>show processlist;

2. Command to kill the running query(helpful to kill long running query)

mysql>show processlist;
kill "number from first col";

3. Restore from mysql backup(.sql  or .mysql file)

mysql -u username -p password databasename < file.sql