Category Archives: Web Programming

Articles to help and guide developers with web programming

Full MySQL Search & Replace in All Databases and Tables

If you get into half of the database stuff that I regularly get into, you probably have a need to replace a specific string, such as a URL, very often – especially if you are cloning databases for use with WordPress. Sure, there are a lot of plugins or programs out there which do the same thing, but most of them avoid three-dimensional arrays and Read More →

How to Exclude Specific Databases from an –all-databases MySQL Dump

There may come a time where you need to make a complete database dump on your MySQL server, yet for whatever reason, you need to exclude databases. In my case, I needed to exclude a certain database so that when I combined multiple databases into one, another database’s tables didn’t get overwritten during the conversion. If you’re familiar with the grep command and piping, you Read More →

Convert WordPress Multi-DB back to Single DB

If you have used the WPMU Multi-DB plugin to fragment your databases from a single instance to 16 or more databases, there may come a time where you need to merge all of those databases back into one. In my case, I want to be able to use Backup Buddy to backup and migrate WordPress blogs. Here are the steps on how to accomplish this Read More →

How to Move or Clone a Single Site or Multi Site WordPress Installation

If you ever have the need to move a WordPress site or a network of WordPress sites to a new server, it can be an outright frustrating task due to all of the settings and data that get accumulated over time. This article is written to be a quick reference for this seemingly daunting task. Eventually I may turn this article into a script to Read More →

Install Homebrew & Ruby on Mac OSX Lion

The purpose of this article is to help you configure Mac OSX so that it has a package manager (similar to apt-get, YUM, Pacman or Portage on Linux distributions), and to update you to the latest version of Ruby (1.9.3 at the time of this writing). Currently, Mac OSX Lion 10.7.4 has Ruby version 1.8.7 which is slightly out of date. Installing Homebrew Homebrew is Read More →

Importing Images Into WordPress from SquareSpace

This article is a continuation of a previous article that I wrote titled Migrating Blog Content and Assets from SquareSpace to WordPress. That article showed you how to actually get the content of the blogs from SquareSpace into WordPress. This article show you how to get the files and images. Install Firefox and the DownThemAll Extension There is an extension for the Firefox Browser called Read More →

Migrating Blog Content and Assets from SquareSpace to WordPress

Rather than explaining why anybody would want to migrate content from SquareSpace to WordPress, I thought it would be more efficient to just dig in. So, in order to migrate content and assets from SquareSpace to WordPress, you will need to follow these steps: Configure WordPress for importing data from SquareSpace Before you do anything, you will want to make sure that WordPress is configured Read More →

RegEx for Redirection: A Reference Guide

Regular Expressions are very handy and save you a lot of time when you have the need to manipulate a lot of data in a little bit of time. When you have multiplestrings where parts of them are the same, they are considered a pattern. Regular expressions can be built to match those patterns and manipulate them in many ways. Meta Characters A metacharacter is Read More →

Setting Up the Eclipse IDE With PHP

For Php developers, there are two options for setting up the Eclipse IDE. You can install the Php only version which is made specifically for those who use Php and only Php, or you can install the classic version and add Php into it. Systems Admins will want to install the classic version and add Php to it because of other tools that may be Read More →

Remove DOS EOL ^M Character from File

If you have the ^M character in your file, it is a Dos/Windows end of line character that is tough to get rid of. You could always ignore it, but the possibility of it corrupting a file is very high. Some editors such as Nano don’t even seem to show this character by default – maybe Nano strips it out – I’m not sure at Read More →

Post Navigation