WordPress Database Migration Bash Script
By: Wil Helser
I HATE migrating WordPress databases! Not that it’s hard or takes much time… just that it’s one of those mundane daily tasks that can pull me out of my zone if I’m not careful. So… I wrote a simple Bash script that will dump a WordPress database, update the URLs ( from local to production or staging, etc. ) and then push the dump to the new database. It’s not super sophisticated, but it gets the job done.
You can grab it on GitHub here …. The link is actually to a repo for my WordPress-related Bash scripts, but I’ve only written one so far. I have a few others that I use daily, but they’re written specifically for my particular set-up. I’m working on making them more flexible so they can be used on any system. I should have a few more up there in a few days.
Hope it helps a little!