![8vl3onvznkopxa6ny9995yrc4gw[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/8vl3onvznkopxa6ny9995yrc4gw1-175x150.jpg "Awk & sed Snippets for SysAdmins")
Articles tagged with: database
Selecting CMS Software
If you are looking for an open-source content management system, your choices are likely to boil down to these three: Joomla!, WordPress, and Drupal. Professional CMS developers tend to disregard WordPress as a purely blogging …
Remove Duplicate Posts in WordPress
Below is the SQL script that will attempt to identify and remove duplicate posts in your WordPress database. This script can be useful for autoblogging. If you use plugins like WP-o-Matic to pull full-text RSS …
Duplicating WordPress Installation
Whenever you upgrade your WordPress installation or do development work, it is always a good idea to be working on a copy of your main site and not on the real thing. Copying WordPress installation …
MySQL Global Search and Replace Script
A day will eventually come when your need to find and replace a string of text in your database. You don’t know which row, or which column, or which table. Heck, you may not even …
Passing MySQL Commands from Shell Script
Running MySQL commands from a shell script is a relatively simple task that has a lot of people baffled. Some say its too complicated and suggest using PHP or Perl, others claim doing so is …
Linux and High I/O Wait
When you look at the CPU activity of your computer, one of the parameters is the iowait. This value shows how much time your CPU wastes while it is waiting for I/O operations for complete. …
WordPress Quick Upgrade for Linux
Never ever upgrade WordPress to the latest version as soon as it comes out, unless you want to be the guinea pig dealing with the new bugs and incompatible plugins. Even if the new version …
Effective Virus Protection
How do you protect your computer from viruses? Most computer users just buy antivirus software, install it, and reboot their PC – done. If only it was that easy. Over the past several years percentage of home and business computers infected with viruses has been steadily growing. Most PCs are sold these days with preinstalled antivirus software. And yet, the number of infected computers keeps on growing…
Generating complex SQL queries with shell scripts
It is sometimes necessary to use complex select and insert queries with dozens of variables. Writing such queries by hand is a tedious process and the chance of making a mistake is high. A few …
![8vl3onvznkopxa6ny9995yrc4gw[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/8vl3onvznkopxa6ny9995yrc4gw1-80x80.jpg "Awk & sed Snippets for SysAdmins")
![rhd3hj6zvnqeth7qo8em0alduj0[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/rhd3hj6zvnqeth7qo8em0alduj01-80x80.jpg "Synology NAS Hacks")
![ytioq398kc1wnvvz95uixhcn5ii[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/ytioq398kc1wnvvz95uixhcn5ii1-80x80.jpg "WordPress: Post-processing of the image failed")
![9dwz62kvm0gtjya9kwb7pawtk9y[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/9dwz62kvm0gtjya9kwb7pawtk9y1-80x80.jpg "Finding Duplicate Photos")
![tq9mhhd5xy2q0kto2j1785n6odv[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/tq9mhhd5xy2q0kto2j1785n6odv1-80x80.jpg "NFS I/O Stats with Logging")
![iwoau71okwxqh4jv3k4ook32qps[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/iwoau71okwxqh4jv3k4ook32qps1-80x80.jpg "Finding Cron Jobs")
![4ucne6vs8m7hqdl0el9ddqd1sql[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/4ucne6vs8m7hqdl0el9ddqd1sql1-80x80.jpg "Inventorying NFS Mounts and Mount Options")
Latest Comments