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 | ||
| + | </ | ||