Difference between revisions of "MySQL Commands snippets"
From DevOps Notebook
(3 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
[[MySQL all databases backup in separate files]]<br> | [[MySQL all databases backup in separate files]]<br> | ||
[[Restore single MySQL table from a full database mysqldump backup file]]<br> | [[Restore single MySQL table from a full database mysqldump backup file]]<br> | ||
+ | [[mysqldump all tables from database in separate files]] <br> | ||
+ | [[Update mysql user password]]<br> | ||
+ | |||
+ | === Disable query cache without mysql restart === | ||
+ | <pre> | ||
+ | mysql> SET GLOBAL query_cache_size = 0; | ||
+ | </pre> | ||
+ | === Increase MySQL Connections without restart === | ||
+ | <pre> | ||
+ | mysql> show variables like 'max_connections'; | ||
+ | mysql> SET GLOBAL max_connections = 1000; | ||
+ | </pre> |
Latest revision as of 10:03, 2 August 2022
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;