Vicidial Database check,repair,optimize command & Root cause and precautions for database crash.

Опубликовано: 18 Январь 2021
на канале: Ajit Kumar
2,739
30

#vicidial #repair #mysqlrepair
Mysql/Mariadb Command to check , Repair and optimize the tables.
Root cause for Database crash.
Precautions for vicidial database crash.

Mysql Database check command
mysqlcheck –uroot –p --check --all-databases
mysqlcheck –ucron –p1234 --check --all-databases

Mysql Database Repair command
mysqlcheck –u root –p --auto-repair --all-databases
mysqlcheck –ucron –p1234 --auto-repair --all-databases

Mysql Database Optimize Command
mysqlcheck –u root –p --optimize --all-databases

Force repair the table
REPAIR TABLE tablename USE_FRM

Vicidial Mysql/mariadb database maintanence
   • how to delete old call logs and other...  
https://www.striker24x7.com/2020/07/h...