rordi/mysql-cheatlist.md

## mysql-cheatlist.md

      
    Raw
  

              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;