Below 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
How 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 Virtualmin MySQL Slow Query Log Setup and View
How to setup Slow Query Logging in MySQL in Virtualmin on CentOS. Steps: 1. Setup Slow Query logging for MySQL 2. Setup MySQL slow Query log viewing in Virtualmin 1. Setup Slow Query logging for MySQL Log in to…
How to: CentOS 6 Virtualmin Logwatch Install and Configure – Mail to Email – Disable Service Monitoring – Debug and fix – MySQL and HTTP Error
This 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…