Hangs when importing database tables

  • Resolved elsmore

    (@elsmore)


    2 years, 10 months ago

    I’m trying to import from Multisite to a single site, but the process hangs each time at 43% – Importing database tables(8%). I deactivated multisite plugins before creating the export.

    I’ve checked the logfile, but I can’t see any obvious errors. I also enabled the WordPress debug log, but nothing was created following the attempted export.

    Strangely, the site did import once, but it was during testing and I wasn’t able to use the import due to it being out of date (i.e. didn’t have recent WooCommerce orders) All the live migrations I’ve tried have failed at the same place.

    Any help appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Codexonics

    (@codexonics)

    Hello Elsmore,

    Thank you for using Prime Mover in your projects! Usually when import hangs it has something to do with lack of memory or a runtime error. Strange you didn’t catch any errors in the log (with debugging enabled).

    Can you please try doing he restore using our latest Prime Mover 1.6.1-beta2 version? Please re-test as follows:

    • Download the latest Prime Mover 1.6.1-beta2 to your Desktop.
    • Deactivate Prime Mover 1.6.0 and uninstall delete that old version.
    • [OPTIONAL] Since you are restoring to a single site – it would be great if you can start with a fresh WP single-site installation to make sure the dB is clean. If this is not possible skip this step.
    • Install/upload Prime Mover 1.6.1-beta2 and activate it to your site (network activated if multisite).
    • Restore the package.
    • Check if the restore still hangs on the import database process with 1.6.1-beta2 version.

    The beta version has bug fixes on database restore errors we’ve seen during testing. It would be great if you can try that to see if it works.

    If you are still having the issue after using the latest beta:

    • Upload the WPRIME package to Gdrive or Dropbox.
    • Contact us here and provide us the link to download the package.
    • If you can attached any migration or updated error logs that would be great.

    We will try to reproduce the issue on import DB hang on our test servers using your package and then debug what is causing it.

    If the beta version fixes the issue – please use that version for now and mark this ticket as resolved. An official stable version will be released in a couple of days.

    Thank you and have a nice day!

    Cheers,
    Emerson

    Thread Starter elsmore

    (@elsmore)

    Hi Emerson,

    Thanks for your reply. Unfortunately the 1.6.1-beta2 version hasn’t made a difference – it still hangs at the DB import stage. This was using a fresh destination WP install, both source and destination WP v6.

    I will upload the WPRIME package and log to Dropbox and contact support as you requested.

    Plugin Author Codexonics

    (@codexonics)

    Hello Elsmore,
    Thanks for the update. Sure, that’s great – we will check the package to see if it’s an issue with the package or something to do with your target server. Please also include the Site info data (Prime Mover -> Advanced -> Export site info) so we will know more about your WordPress and server configuration. Thanks again!

    Cheers,
    Emerson

    Thread Starter elsmore

    (@elsmore)

    All working now – increasing max_allowed_packet resolved the issue. Thanks for your help!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Hangs when importing database tables’ is closed to new replies.