====== Check and optimise mysql databases ======

===== Commands =====

==== Check ====

<code bash>$ mysqlcheck -c -p[pass] -A</code>

^ Parameter ^ Alias ^ Meaning ^
| --check | -c | Check tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |

==== Analyse ====

<code bash>$ mysqlcheck -a -p[pass] -A</code>

^ Parameter ^ Alias ^ Meaning ^
| --analyze | -a | Analyse tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |

==== Optimise ====

<code bash>$ mysqlcheck -o -p[pass] -A</code>

^ Parameter ^ Alias ^ Meaning ^
| --optimize | -o | Optimise tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |

==== Repair ====

<code bash>$ mysqlcheck -r -p[pass] -A</code>

^ Parameter ^ Alias ^ Meaning ^
| --repair | -r | Repair tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |