Repository navigation
<img> tags when moving db between servers #95
Description
Is there a preferred method of managing the urls for images (and other assets) in posts and pages that have a full host and path, when they're moved between servers with, for instance:
cap staging genesis:down:db
When I run the above, my posts/pages all have the absolute staging url in all assets. Is there a workaround for this? Or a way we should be building link and assets references?
Activity
EvanK commentedon May 1, 2015
evolution/wordpress#37 has a (currently in-progress) fix for this, filtering the dumped sql file through perl to update urls for the target environment:
Contingent on free time, I might try to backport this into Genesis
mcheck commentedon May 2, 2015
In Genesis, I implemented my own search-replace using awk, but it does not handle serialized values. So it potentially gets to be a mess. Works for the most part though.
In Evolution, I added a cap task that uses wp-cli to change the values. It works great. Wp-cli search-replace handles all the serialization too. Brilliant you guys adding that to the project. My implementation is kinda hacky, because I couldn't figure out how to get the current name of the stage, and future name of the stage, but it's a good start.
EvanK commentedon May 3, 2015
Drat, I hadn't thought about serialized values.
I would definitely prefer to use wp-cli over a perl invocation, but it only supports string replacements (for now: wp-cli/wp-cli#1600)
mcheck commentedon May 5, 2015
It's not as elegant but why wouldn't just string replacements work? My understanding is that we're just changing the stage.domain.tld portion of the urls.
What else is being changed between envs that would require regex?
EvanK commentedon May 5, 2015
My concern would be catching branched staging subdomains (
custom-branch.staging.example.com), though on second thought the changes in evolution/wordpress#37 should make this a non-issuemcheck commentedon May 6, 2015
Great! If there is someway I can help, don't hesitate to ask.