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
The following command may be very useful for changing the permissions of a file type such as .php...
From time to time you may find the cPanel backup system taking longer and affecting production...
Failed to start tailwatchd. Unit tailwatchd.service entered failed state. tailwatchd.service...
Over the time or due to spammers the eximstats database file may grow to a large size. To clear...
If you have a problem with your VPS time not staying sync in a Xen VPS you will want to enable...
LiveChat
Support
Blog
Affiliates
