MySQL Commands snippets

Get limited number of records from mysqldump
MySQL all databases backup in separate files
Restore single MySQL table from a full database mysqldump backup file
mysqldump all tables from database in separate files

Disable query cache without mysql restart

SET GLOBAL query_cache_size = 0;