How to: MySQL search and replace, PHPMyadmin, Joomla Params etc.

RedditDiggFacebookTwitterFlipboardPinterestLinkedinLineBelow are a few SQL statements I use to search and replace the value of params in Joomla, in this case I added another value. UPDATE  `joomla_database_name`.`j15_modules` SET  params = replace(params, '"cache":"0"', '"backname":"1","backlink":"1","cache":"0"') WHERE  `j15_modules`.`module` ="mod_menu"; Here is another statement…

How to: CentOS Virtualmin MySQL mysqlcheck Cronjob

RedditDiggFacebookTwitterFlipboardPinterestLinkedinLineHow to setup a mysqlcheck cronjob in Virtualmin to run automatically every midnight and make it check, optimize and repair all of your databases and tables. Setup mysqlcheck cronjob in Virtualmin  – Login to Virtualmin – browse to Webmin >> System >> Scheduled…

How to: CentOS 6 Virtualmin Logwatch Install and Configure – Mail to Email – Disable Service Monitoring – Debug and fix – MySQL and HTTP Error

RedditDiggFacebookTwitterFlipboardPinterestLinkedinLineThis How to contains instructions on how to install and configure Logwatch 7.4.0 on CentOS 6 running Virtualmin, and how to – Configure Mail to Email –  Disable Service Monitoring – Debug and Fix MySQL and HTTP Error Checking: 1. Install…