mysql-cheatlist.md

MariaDB / MySQL Cheatlist

Import a dump file:

mysql -u userName --password=yourSecret dbName < ./path/to/dump.sql

Run command non-interactive:

mysql -u userName --pasword=yourSecret dbName -e 'SELECT * FROM my_table;'

Log in to interactive shell:

mysql -u userName --password=yourSecret dbName

Show all running processes / queries on the server:

show processlist;

Kill a running process / query on the server:

kill processId;