en:linux:mysql:dbactions

Draft | Approver: psycore

Check and optimise mysql databases

$ mysqlcheck -c -p[pass] -A
Parameter Alias Meaning
--check -c Check tables
--password -p Password (without spaces)
-all-databases -A All databases
$ mysqlcheck -a -p[pass] -A
Parameter Alias Meaning
--analyze -a Analyse tables
--password -p Password (without spaces)
-all-databases -A All databases
$ mysqlcheck -o -p[pass] -A
Parameter Alias Meaning
--optimize -o Optimise tables
--password -p Password (without spaces)
-all-databases -A All databases
$ mysqlcheck -r -p[pass] -A
Parameter Alias Meaning
--repair -r Repair tables
--password -p Password (without spaces)
-all-databases -A All databases
  • en/linux/mysql/dbactions.txt
  • Last modified: 2023/10/24 21:35
  • by psycore