Difference between revisions of "MySQL Commands snippets"
From DevOps Notebook
| Line 3: | Line 3: | ||
[[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> | [[mysqldump all tables from database in separate files]] <br> | ||
| + | |||
| + | |||
| + | === Disable query cache without mysql restart === | ||
| + | <pre> | ||
| + | SET GLOBAL query_cache_size = 0; | ||
| + | </pre> | ||
Revision as of 13:56, 13 July 2021
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;
