Restore a WordPress Database to Localhost
Database / PHP

Restore a WordPress Database to Localhost

Working with WordPress, I often will take a production database and restore it to my local server to verify changes and further aid in development. When doing so, I will always run WordPress under a named virtual host, with frequent production backups allowing me to mimic the production environment. This article will discuss the steps necessary to backup and restore a production MySQL database to a local development environment, and configure it to run against a local named virtual host or URL.

[ Read More ]

Magento Newsletter Subscribers Import Script
PHP

Magento Newsletter Subscribers Import Script

I was recently helping a client setup and configure their Magento newsletter module, and worked to help them get a large part of their subscriber base imported into Magento from external sources. To accomplish this, I created a newsletter subscribers import script for Magento that helped them accomplish a quick import of their subscriber base that existed outside of their Magento installation.

[ Read More ]

How to Setup the Magento Cron Job
Linux

How to Setup the Magento Cron Job

I’ve encountered way too many Magento installations that were never configured to execute the Magento cron job, ultimately causing confusion and problems. This post is meant to be a tutorial to help people enable and setup the cron job to execute as required by Magento, as well as answer some questions as to why the Magento cron job should be enabled.

[ Read More ]

MySQL Client Debugging Using the General Query Log
Database

MySQL Client Debugging Using the General Query Log

I was recently working on a project at work and needed to do some debugging on a local environment of the queries being executed against a MySQL database from the application I was working on. To accomplish this, I used the MySQL general query log, and wanted to share how to enable and configure the general query log.

[ Read More ]

Enable Shortcodes in WordPress Text Widgets
PHP

Enable Shortcodes in WordPress Text Widgets

Have you ever wanted to use a WordPress shortcode in a text widget, or have you ever attempted to do so with undesired results? I have, and wanted to re-share a common little code snippet that allows you to use a WordPress shortcode from your theme or plugin within a text widget!

[ Read More ]