MySQL Repair and Optimize All DB


mysqlcheck -u da_admin -p --auto-repair --optimize --all-databases

veya

mysqlcheck -Aor -u root -p
A = all databases
o = optimize
r = repair

bun daha kolay yonetmi varmis 2024 30 eylulde ogrendim

/usr/bin/mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --skip-write-binlog --optimize --all-in-1 --all-databases