josescasanova

If you find the following useful my donation address is: aEgoFC75sP78gT55em1QYcL8DNYZ78ewJ5

1. Go here: https://console.aws.amazon.com/ec2sp/v1/spot/home?region=us-east-1

2. Click: "Request Spot Instances"

3. Request type: "Request and Maintain"

4. Choose how ever many servers/vcpus you want in the "Target Capacity" section.

josescasanova

If you find the following useful my donation address is: aEgoFC75sP78gT55em1QYcL8DNYZ78ewJ5

1. Go here: https://console.aws.amazon.com/ec2sp/v1/spot/home?region=us-east-1

2. Click: "Request Spot Instances"

3. Request type: "Request and Maintain"

4. Choose how ever many servers/vcpus you want in the "Target Capacity" section.

josescasanova

Fixing npm On Mac OS X for Homebrew Users

Installing node through Homebrew can cause problems with npm for globally installed packages. To fix it quickly, use the solution below. An explanation is also included at the end of this document.

Solution

This solution fixes the error caused by trying to run npm update npm -g. Once you're finished, you also won't need to use sudo to install npm modules globally.

Before you start, make a note of any globally installed npm packages. These instructions will have you remove all of those packages. After you're finished you'll need to re-install them.

josescasanova

SET @oldsite='http://oldsite.com'; 
SET @newsite='http://newsite.com';
UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

/* only uncomment next line if you want all your current posts to post to RSS again as new */
#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);