Month: April 2015

mySQL: repair and optimize all tables in all databases


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /homepages/3/d98111892/htdocs/insanelabs/htdocs/wp-content/plugins/ultimate-google-analytics/ultimate_ga.php on line 524

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

You will be asked for root password and command will run. If you want to do it through cron, put your password immediately after -p… like -ppassword.

Linux: edit crontab with nano instead of vi


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /homepages/3/d98111892/htdocs/insanelabs/htdocs/wp-content/plugins/ultimate-google-analytics/ultimate_ga.php on line 524

Everyone hates vi… I sure do. If you can’t or don’t want to permanently change your crontab editor use this:
env EDITOR=nano crontab -e

Linux: VMware Tools on Red Hat or CentOS Prerequisites


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /homepages/3/d98111892/htdocs/insanelabs/htdocs/wp-content/plugins/ultimate-google-analytics/ultimate_ga.php on line 524

This should do it:
yum install perl gcc make kernel-headers kernel-devel audit binutils glibc-headers

If vmware tools install cannot find your linux headers, throw these in too and try again:
yum install kernel-headers-`uname -r` kernel-devel-`uname -r`