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
Update mysql user password

Disable query cache without mysql restart

mysql> SET GLOBAL query_cache_size = 0;

Increase MySQL Connections without restart

mysql> show variables like 'max_connections';
mysql> SET GLOBAL max_connections = 1000;