Posts Tagged “query”

Today I was adding a note to a WordPress article I had written a couple of days ago and it appeared to POST without issue after I clicked the Update button in the WordPress admin. I went to the front-end of the site to verify the new content formatted correctly and to my surprise it wasn’t displaying so I figured I must have left a HTML tag or something open since I didn’t get any errors within the WordPress admin when I clicked the Update button for the Post. After further review the content didn’t exist and it appeared that the article had not posted the update at all since there were zero revisions from today. Fixing the problem is easy by using the below information that describes where I located the error, the error itself, and how to resolve it by issuing a single MySQL command.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , , , , , , , , , , , ,

Comments No Comments »

Earlier today I was upgrading some packages on a CentOS Linux server and was curious what applications were actually installed with the coreutils RPM package. I knew that this was one of the main RPM packages that had a ton of various applications installed with it however I was not sure specifically which ones. Below are some examples of how to use RPM to find out exactly what is installed with a specific RPM package.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , , , , ,

Comments No Comments »

When working on a project where I was required to merge two sets of like data to make sure there were not any conflicts I needed a way to dump PostgreSQL database tables to Excel formatted .CSV files. Anyhow dumping Postgres tables to excel is easy to do by following the below directions.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , , , ,

Comments No Comments »

Using whois can be a valuable tool to find out more information about a domain via the command line in Linux. A typical whois query can be performed to find out where the domain was purchased and using it again with the -h (host switch) can provide more detailed information about the domain. Using the -h switch will typically provide information such as who purchased the domain, when the domain was purchased, when the domain expires, etc. Below are a couple basic examples of how whois can be used followed by whois queries with the output.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , ,

Comments No Comments »

Here are the ones I tried. Hope the comments aren’t too confusing

  1. Simple Rails Log Query Analyzer
    • Ran ruby bin/query_log_analyzer.rb ../log/production.log
      • production.log.1 (small log file ~25MB) Just printed the “Totals” heading with no results
      • production.log (large log file ~400MB) Ran for a long time and nothing happened
  2. Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , ,

Comments 1 Comment »