meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
linux:databases [2015/07/13 07:50] – niziak | linux:databases [2022/04/11 10:27] (current) – niziak | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Databases ====== | ||
+ | |||
===== Reset password ===== | ===== Reset password ===== | ||
Start database without permission checking: | Start database without permission checking: | ||
Line 46: | Line 48: | ||
</ | </ | ||
+ | === Optimize databases === | ||
+ | <code bash> | ||
+ | #!/bin/bash | ||
+ | mysqlcheck --all-databases | ||
+ | mysqlcheck --all-databases -o | ||
+ | mysqlcheck --all-databases --auto-repair | ||
+ | mysqlcheck --all-databases --analyze | ||
+ | </ | ||