Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboBelow 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"')…
How to: CentOS Virtualmin MySQL mysqlcheck Cronjob
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboHow 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 –…
How to: CentOS Virtualmin MySQL Slow Query Log Setup and View
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboHow 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…
How to: CentOS 6 Virtualmin Logwatch Install and Configure – Mail to Email – Disable Service Monitoring – Debug and fix – MySQL and HTTP Error
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboThis 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…