Posts Tagged with “WordPress”

Comments Closed

Useful SQL queries for migrating a WordPress database

First, if at all possible, use the WP Migrate DB Pro or BackupBuddy plugins to migrate your WordPress database. The money spent will save yourself a lot of frustration and hair pulling, and hours if not days of cleanup and massaging of the WordPress database.

But if that’s not possible, welcome to my world for the past week. I’ve had to migrate a WordPress database without my favorite migration tools. After scouring the web for tutorials and tips, I’m compiling them here for easy reference.

Gather Your Tools

First thing you need is to get your hands on the following:

1. Database name, prefix, user and password.

You can find these defined in the wp-config.php file. In the following examples, be sure to swap out the database name wordpress and prefix wp_ with the correct values from your situation.

2. Access to phpMyAdmin so that you can interact with the database.

We’ll be running the commands below through the SQL tab in phpMyAdmin.

phpmyadmin-sqlquery

Running SQL queries on your database with phpMyAdmin

You could also connect directly to MySQL through the terminal / shell prompt. Good luck if you don’t have phpMyAdmin.

3. Backup, Backup, Backup

Don’t say I didn’t warn you. Export your untouched database and lock it up. If all goes wrong, restore to this backup.

Change the Site URL

The first thing you would want to do is to change the site URL. You can browse the wp_options table for the siteurl and home options values directly, or you can use this SQL command:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'siteurl' OR option_name = 'home';

Next, you’ll want to replace all instances of oldsiteurl.com in your post’s contents and GUID.

UPDATE wp_posts SET post_content = REPLACE (post_content, '//www.oldsiteurl.com', '//www.newsiteurl.com');
UPDATE wp_posts SET guid = REPLACE (guid, '//www.oldsiteurl.com', '//www.newsiteurl.com');

Read More »

Comments Closed

Sweden With Love

Happy day! We are finally live! A brand new online experience. #swedenwithlove. Beautifully designed by @thedarlingtree. xo

Sweden With Love was a ClickWP project for Ulrica Wihlborg. It features a custom WordPress theme built on the Genesis Framework. Jo Klima from The Darling Tree created the design while I was responsible for coding the theme and site implementation.

Read More »

Comments Closed

I wrote a guest post for Phase Creative, an awesome WordPress production small business in Sydney.

So, what should you do to ensure that your website is running in tip-top shape? Here is myEssential WordPress Maintenance Checklist. The tasks on this checklist are divided into daily, weekly and quarterly tasks and following this schedule will only take 10 minutes a week with an additional 30-60 minutes per quarter.

Read the full post →

Comments Closed

sandbox

You’ve created your WooCommerce store, uploaded all your products and are ready to accept payments via PayPal. But how would you know if PayPal will play nice with your store?

Most people will make a small purchase with a friend’s PayPal account as a live test. But that costs real money and is annoying if you have to test multiple times. This post explains how to test the payment system using the PayPal Sandbox.

The PayPal Sandbox is a place where you can test your shopping cart and other PayPal integrations in a realistic way, except that no money changes hands. This means you can test your PayPal processes in the Sandbox and know they will behave the same on the when you go live.

Read the full article on ClickWP: Test payments in WooCommerce with the PayPal Sandbox

Comments Closed

wp10logoIn conjunction with WordPress’ 10th Anniversary I wrote down some reflections on my journey with WordPress on the ClickWP blog:

WordPress is one of the blessings I count every day because it is entirely free to use. It was created freely and given away freely to the world. I am where I am today because of this generosity.

Happy birthday WordPress ♥

At the beginning of 2011, I began hosting my websites on Site5. I have been singing their praises and recommending everyone I know to them. Today iThemes publicly announced their endorsement of Site5 hosting (and how terrible Hostgator is too). I’m really excited about the development because iThemes is a major WordPress plugins and themes vendor, so their endorsement confirms my feelings about Site5. Also, the CEOs of both companies have been communicating directly which will hopefully result in even better WordPress compatibility with Site5. Check out the announcement post, Site5 has a 6-month free trial (!) for the iThemes community.

Disable shortcodes for ElegantThemes

Go to ePanel/custom-functions.php and remove:

require_once(TEMPLATEPATH . '/epanel/shortcodes/shortcodes.php');

However I recommend that you don’t use ElegantThemes. Sure they’re cheap, but they don’t offer Automatic Updates which makes their themes pretty insecure and vulnerable to hackers.

If you want high quality themes with rock solid security and top-notch support, go with StudioPress or WooThemes.

WTOTW: Automatically post selected Instagram photos to your blog with ifttt

My Instagram yesterday got a lot of likes and apparently people are really interested to do this, so here’s a quick tutorial how.

This tutorial will show you how to post *selected* Instagram photos to your WordPress blog, automatically. All you need to do is to tag your Instagram with a hashtag for it to work.

ifttt

The key to doing this is a service called ifttt, which is short for “if this then that”. Basically you tell it to watch for a trigger (if this) and do something in response (then that). See the quick one-page guide on their site. Tip: ifttt is pronounced like ‘lift’ without the ‘l’. Read More »