From time to time you will find repairing and optimizing your databases are necessary. From a shell the following may be useful for mySQL and MariaDBs: Repair and optimized DBs find /var/lib/mysql -name '*.MYI' -exec myisamchk -r {} \;find /var/lib/mysql -name '*.MYI' -exec myisamchk -o {} \; Force repair: find /var/lib/mysql -name '*.MYI' -exec myisamchk -rf {} \; mysqlcheck Repair and Optimize: mysqlcheck --repair --use-frm --all-databases mysqlcheck -o -A
find /var/lib/mysql -name '*.MYI' -exec myisamchk -r {} \;find /var/lib/mysql -name '*.MYI' -exec myisamchk -o {} \;
find /var/lib/mysql -name '*.MYI' -exec myisamchk -rf {} \;
mysqlcheck --repair --use-frm --all-databases mysqlcheck -o -A
Although at times faster, you will find InnoDB a very large headache when it comes to table...
error: db3 error(-) from dbenv->failchk: DB_RUNRECOVERY: Fatal error, run database recovery...
The error Failed to access DBM file /var/cpanel/secdatadir/ip: Permission denied can occur on...
When encountering the following:E Sysup: Needed system RPMs were not installed: yum-utils*****...
While viewing exim_mainlog and seeing the following: enforce_mail_permissions: Domain...
LiveChat
Support
Blog
Affiliates
