Dieskim`s Blog

  • Home
  • About
  • Hire Me

MySQL

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

DieSkim September 17, 2012 CentOS, Joomla, Server, Virtualmin 2 Comments

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…

Read more

How to: CentOS Virtualmin MySQL mysqlcheck Cronjob

DieSkim July 16, 2012 CentOS, Server, Virtualmin No Comments

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…

Read more

How to: CentOS Virtualmin MySQL Slow Query Log Setup and View

DieSkim July 16, 2012 CentOS, Server, Virtualmin No Comments

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…

Read more

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

DieSkim July 3, 2012 CentOS, Error, Server, Virtualmin 15 Comments

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…

Read more

Donate

If you think this blog has helped you in any way, please consider a donation as a token of your appreciation

Recent Comments

  • A Oost on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • Amanda on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • Mohammed on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • ADB Xiaomi Mi Pad start Hardware Test app without Dailer – Calibrate Display, Proximity Sensor – Dieskim`s Blog on How To: Xiaomi MIUI V6 – Enable Developer Options and turn on and USB Debugging
  • Appcelerator Titanium Alloy JPUSH Push Notification Module Android Update – Local Notifications – Custom Layout – Dieskim`s Blog on Appcelerator Titanium Alloy JPUSH Push Notification Module – iOS and Android, China Push Notification- NON GCM
  • How To: Xiaomi Hongmi / Redmi Note 3 (SnapDragon/Qualcomm) – Flash Chinese Rom to Global Rom – Locked Bootloader – Mac OSX / Linux Ubuntu / Windows via Virtualbox – Dieskim`s Blog on How To: Xiaomi MIUI V6 – Enable Developer Options and turn on and USB Debugging
  • Ronnie on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • Martin on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • PrajaktaS on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • PrajaktaS on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • harun on How to: Root any Android Phone, Spreadtrum, Chinese Phone
  • Emma on How to: Spreadtrum ADB (Android Debug Bridge) Drivers / Setup – ZTE U791 – Windows 7 64Bit and MAC
  • bao on How to: Root any Android Phone, Spreadtrum, Chinese Phone
  • Rainer on How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • Custom HTTP header fields stripped - QuestionFocus on SOLVED: Apache 2 PHP 7 FCGID not allowing / removing / stripping custom HTTP Headers

Recent Posts

  • SOLVED: nginx http to https redirect loop cloudflare ssl
  • SOLVED: Apache 2 PHP 7 FCGID not allowing / removing / stripping custom HTTP Headers
  • How To: Xiaomi Hongmi / Redmi Note 3 (SnapDragon/Qualcomm) – Flash Chinese Rom to Global Rom – Locked Bootloader – Mac OSX / Linux Ubuntu / Windows via Virtualbox
  • SOLVED – How to: Get iDVD 7 and Enable Dual Layer Image Creation without DVD Drive
  • Appcelerator Titanium Alloy JPUSH Push Notification Module Android Update – Local Notifications – Custom Layout
  • How To: Connect Logitech Non-Unifying Mouse/Keyboard K260/M210 to Nano Unifying Receiver – Windows/MAC/Linux
  • How To: Count.ly Server Backup Script – Local, Remote, Rotate – Automated Daily via Cron
  • How To: Linux SSH KEY Password Free Automatic Config Authentication – Backup, SFTP, SCP
  • How to: Linux Find Large Files on Disk
  • How to Linux – Checking Free Disk Space Human Readable

Tags

2.5 ADB alloy Android apache app appcelerator apps backup CentOS china chinese cloudflare cron email error Firewall fix font gcm global google how to install ios joomla JPUSH linux mac module MySQL php play push Root secure server setup ssh Titanium update usb virtualmin xiaomi yum
© 2008 – 2019 Dieskim