Blog - Orange Box Designs

Latest News

Interesting topics on the latest design trends and How-To’s.

WordPress MySQL Find / Replace When Moving Domains

July 17, 2017/in How-To's /by Ian

Great piece of code to use when moving a WordPress site from one domain to another; quick way to replace the old domain name in the DB with the new one. UPDATE wp_options SET option_value = replace(option_value, ‘http://olddomain.com’, ‘http://newdomain.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; UPDATE wp_posts SET guid = replace(guid, ‘http://olddomain.com’,’http://newdomain.com’); UPDATE […]

Syncing Filezilla Sites across multiple computers with Google Drive or Dropbox

July 17, 2017/in How-To's /by Ian

1. Find your site manager file Filezilla keeps all of your sites and access credentials in an XML file called “sitemanager.xml” Here are the most likely locations: Windows 7 & Vista : C:\Users\Yourname\AppData\Roaming\FileZilla\sitemanager.xml Mac OS X: /users/Yourname/.filezilla/sitemanager.xml Linux: /home/Yourname/.filezilla/sitemanager.xml 2. Back it up Just in case something goes wrong in the next few steps. Copy […]