This post originally appeared on the Annexe.

Yes, I’m turning this Tumblr into a dumping ground for stuff that’s not worth putting on my actual blog :)

If you’ve changed your URL in nginx/Apache, and need to modify in the database:

USE wp_database;
BEGIN;
UPDATE wp_options 
SET option_value='http://example.com'
WHERE option_name='siteurl';
UPDATE wp_options 
SET option_value='http://example.com'
WHERE option_name='home';
COMMIT;

DISCLAIMER: I have used reasonable care in preparing the information included in this document, but I do not warrant that such information is error free. I assumes no liability whatsoever for any damages incurred by you resulting from errors in or omissions from the information included herein. Backup all production databases before modification.