Database migration (development and production sites)

[Joerg]

Joerg

October 6, 2017 at 5:59 am

Hello

I’m using Pinnacle for our company website. We do all the development locally in an xampp instance, therefore the URL is http://127.0.0.1/wordpress. The production site is at *Login to see link .

To migrate between development and production sites, I use UpdraftPlus, which includes a “search and replace” option for the database. Unfortunately, this does not work with Pinnacle. The problem is that all of Pinnacle’s settings are stored in one big entry in the wp_options table. And for each parameter value, you also store the value’s length. Any search & replace on a database export, be it done by Updraft, manually or by any other tool, will modify the URL, but leave the parameter length alone. This then breaks Pinnacle, so the target site of such a migration will not work properly.

Is there any way to use Pinnacle in such an environment where development and production have different length URLs? Or do you have maybe a migration tool that also adjusts the value lengths?

thanks a lot!
Joerg