Earlier I set up a development WordPress site that mirrored a live WordPress installation. To do this I dumped the entire WordPress database using mysqldump and then imported it into a new database with mysql. Among other things that needed to be changed I needed to update any links that referenced the live site’s URL with the development site’s URL. Below I provide the command to make such an update to only a matching portion of a column in row located in a MySQL database.
Nagios is an awesome open source application that provides a way to monitor pretty much anything that you can think of on your network. There are tons of plugins written for Nagios that will monitor anything from PostgreSQL database size to the number of users logged into a server. Today I needed to start monitoring the size of a Ruby process that has been growing out of hand so the below is what I came up with being the best solution. Follow the directions below to deploy a Perl script that will use SNMP to retrieve Linux server process size.