Home>Support>Migration from local to server

Migration from local to server

Hi,
when i upload my site online, all the layouts i made with Page Builder disappear; it seems during the backup does not save the Page Builder informations .
I use a plugin named Duplicator which create a .zip file with my entire sites and a php file that extracts the sites with the right settings in the host online.
How can i do tu move Page Builder informations too?

Dennys Previdi

This is our free support forum. Replies can take several days. If you need fast email support, please purchase a SiteOrigin Premium license.

  1. 10 years, 6 months ago Greg Priday
    Hi, I Work Here

    Hi Dennys

    This is something we’re working on. Right now, migration could definitely be smoother, but it works with the WordPress import/export posts functionality. So this is how we’re recommending you migrate your content.

  2. 10 years, 6 months ago Mark Gems

    Hi, I have seen that occasionally this site shows an 403 error message. I thought that you would be keen to know. Thanks

  3. 10 years, 6 months ago Viktor Vigh

    Hi Greg,

    Thank you for your work on the plugin.
    I developed a site locally. But when it came to migration, all the pages were missing that I built with page builder.
    I exported the database with no luck. The WordPress import/export function didn’t work either. I tried it with posts, pages, and so on.

    Can you help?
    Thanks,
    Viktor

  4. 10 years, 6 months ago Marcoevich

    Hi Viktor,

    Have you also moved your entire database to the new domain? I bet Pagebuilder stores information in the wordpress database, that will be lost when you move just the ‘files’ to the new domain.

  5. 10 years, 6 months ago Viktor Vigh

    Hi Marcoevich,

    Yes, I have moved the entire database with urls changed from localhost to the actual.
    This worked for me before, but I had no luck this time.
    Since then I rebuilt the site online. Can you give me some hints for any wp – page builder regarded migration?

    Thanks,
    Viktor

  6. 10 years, 5 months ago Mike

    Hello.
    I had the same issue. This is because different servers – makes serialization by another way. If your content has multibyte strings – it may not be unserialized correctly. There is my solution:

    file: /wp-includes/functions.php line 230 (added preg_replace)

    function maybe_unserialize( $original ) {
    if ( is_serialized( $original ) ) // don’t attempt to unserialize data that wasn’t serialized going in
    {
    $original = preg_replace(‘!s:(\d+):”(.*?)”;!se’, “‘s:’.strlen(‘$2′).’:\”$2\”;'”, $original);
    return @unserialize( $original );
    }
    return $original;
    }

    I hope it will help you.

  7. 10 years, 5 months ago Andrew Misplon
    Hi, I Work Here

    Hi Mike

    Thanks for posting your solution, much appreciated.

  8. 10 years, 3 months ago Simeon Banister

    Can we hear more about this potential solution?

  9. 10 years, 3 months ago Andrew Misplon
    Hi, I Work Here

    HI Simeon

    It’s a core hack so not something we’d recommend.

    We have had a client report successfully migrating Page Builder content using: https://wordpress.org/plugins/duplicator/.

    The other alternative is to re-build and then move content using WordPress Tools > Export.

    Please open a new thread if you have any further questions.

  10. 10 years, 17 days ago Wade Cordts

    Duplicator does not work. Nor does the WordPress Import/Export function. I have tried both 3 times each.

    • 10 years, 17 days ago Andrew Misplon
      Hi, I Work Here

      Hi Wade

      I’ll pick this up on your primary thread.

  11. 9 years, 10 months ago Soylent17

    I was having this issue because I was migrating my data wrong. I was exporting the data, doing a search/replace for the domain name in the exported data, and then importing it into the new database. THIS WON’T WORK. Some of the data is serialized, and the serialization marks string lengths. Therefore, if you change the text inside serialized data, the serialization will no longer be valid. The proper way to migrate is to export and then import the data with NO CHANGES, then run a search replace script. The one I used and highly recommend ([link url=”http://codex.wordpress.org/Moving_WordPress”]as does WordPress[/link]) is by [link url=”https://interconnectit.com/products/search-and-replace-for-wordpress-databases/”]interconnect/it[/link]. I ran this script and it worked like a charm.

    https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

  12. 8 years, 1 month ago gsutcliffe

    @Mike pointed me in the proper direction to fix this issue. Well, at least a script to execute after the database is moved to a new server. Personally I don’t want to use the recommended 3rd party plug-ins for a migration because I write my own deployment scripts, and that adds an unneeded layer of complexity. So instead, this PHP script is run after my import and all SiteOrigin pages display properly and the editor is in place.

    After the database import, execute the script:

    php ./siteorigin.php

    siteorigin.php

    <?php
    
    $conn = new PDO("mysql:host=<hostname>;dbname=<dbname>;", "<username>", "<password>");
    $sql = "SELECT meta_id, meta_value FROM wp_postmeta WHERE meta_key = 'panels_data'";
    $results = $conn->query($sql);
    $sql1 = "UPDATE wp_postmeta SET meta_value = ? WHERE meta_id = ?";
    $stmt = $conn->prepare($sql1);
    
    foreach ($results as $row) {
      $args = array(
        preg_replace_callback('!s:(\d+):"(.*?)";!s',function($m){$len = strlen($m[2]);$result = "s:$len:\"{$m[2]}\";";return $result;},$row['meta_value']),
        $row['meta_id']
      );
      $stmt->execute($args);
    }
    
    ?>
    

    I realize this is an old post, but hopefully someone comes across this having the same problem.

Replies on this thread are closed. Please create a new thread if you have a question, or purchase a SiteOrigin Premium license if you need one-on-one email support.

Get The Most Out of SiteOrigin with SiteOrigin Premium

Find Out More