Is there a way to run this on database dumps?

[interconnectit]

Is there a way to run this on database dumps?

[theMikeD]

Never mind, I wrote my own

https://github.com/theMikeD/wpdbtransfer/

...Mike

[roborourke]

Hi Mike,

Nicely done :)

It's an interesting idea but would require a fair bit of planning to add to
the UI. I've not come across a use-case where I've wanted to search/replace
an SQL dump directly as it'll be just be getting imported somewhere anyway.

Is it to avoid the downtime of possibly running search/replace on a
production site?

[theMikeD]

It's because I'm lazy :)

If I can run it on a command line, then I can make a script to feed it the required variables. And if I can do that, then once I set it up, doing future adjustments is one click: run the shell script that runs the script and presto, done.

I move databases around a lot, so I've found it's just easier to do it with a script, because the interface while awesome still asks me every time to put in the from and to replacement values.

Mine is a dumb fix in that it's not parsing the entire serialized data, just searching for strings and adjusting them. Seems to work so far though. I'll keep an eye on your project for sure, it's very slick.

[roborourke]

@theMikeD I'll close this ticket for now, do check out the CLI script that's available with this if you want to automate. I've updated it with lots of options recently.