Find and Replace SQL for Uploading a Local Wordpress Site
I’m always forgetting processes like this, which are occasional for me. So this is a note of the SQL query I use to get local wordpress site up and running online:
After uploading updated theme files, and importing the local MySQL database to the online site, run this query in the SQL tab of PhpMyAdmin to quickly replace all the copies of the local url with the new online ones.
update `wp_options` set `option_value` = replace(`option_value`, “http://localhost:8888/mysite”, “http://www.mysite.co.uk/wp”);
That’s it! If other references to your localhost exist (eg. as image addresses in your posts, you can run other queries to deal with them, just swap `wp_options` and `option_value` with the relevant table_name and field_name respectively.
- ‘Well, what of it?’ 26 July 2009 | Notes >
- Thus, my dear and civilised reader, 15 February 2009 | Notes >
- The Penny 3 January 2009 | Notes >
No films yet...
-
Efficiency! Organisation! Mutation! Salvation!
How do you know what you want? How do you know when you’ve got it? Where does abstract desire meet with concrete life-processes? Jonathan Lister has some strange Ideas: I thought I’d try them out…
-
‘Well, what of it?’
‘It wouldn’t be our fault, would it, with a crazy fellow like that?’
But he was very anxious, for he was still too cold headed himself to give in to this mass hysteria. Also his pride as a leader was hurt as he saw the mob slipping out of his control and doing wild things far [...] -
New Scaffolding Platform Internal Extension!
Just had this platform inserted into my live/work space. Pretty jolly, huh? Great chap called Marcus sold me the tubes, and as we delivered them together I realised it was going to be a pretty tough job erecting the structure. He agreed to help and it was done inside an hour. Neat. And less dangerous [...]
Archives
Twit Twit Twit
- peaky peking ant and duck, yo? //
- for the twit record, I'm recording @jayfresh's facetime riposte to my 'progressive mtrfkr' jibe: 'Yes: cripplingly progressive' //
- @gathouse (&@michelmishka): the 'why' is, as ever, more difficult. //
- @gathouse (&@michelmishka): http://bit.ly/d8rI4O //
- @michelmishka: So it would seem. My personal brand will sneer at me yet... You seem to have ++flow, and all Nu-tung etc, gosh odd! Lovely. //
- @gathouse: suggest you tool up in appropriate fashion and end the scene in a cloud of innards. http://bit.ly/aKo9SA //
Delicious
Flickr
Colophon
This site uses Wordpress, is set in Hoefler Text & Helvetica Neue, was built on a Mac, and prefers Firefox. I'm still testing in other browsers- help by letting me know if you have any display issues.
Blank is the first wordpress theme I've designed and built from the ground up. But I 'borrowed' and reworked the comments system from Derek Punsalan's Gridfocus.
All content & design, except where mentioned, is © Joshua Bradley, 2009