Import gets stuck after 40% of database restored

  • Resolved licomic

    (@licomic)


    5 years, 8 months ago

    I’m importing a 1.6 GB backup to my Fatcow host. It unpacks the files fine but stalls out when database is at 39 or 40 % restored. I’ve tried twice and had tech support increase the memory setting on php.ini to the max.

    Thanks.

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

    (@yaniiliev)

    Usually, this happens when max_execution_time is not high enough.
    Try to increase it to 1 minute or longer and see if it helps.

    Thread Starter licomic

    (@licomic)

    It’s set 120 seconds. I’m trying it again. Does the plugin have a timeout on the restore of the database?

    Thread Starter licomic

    (@licomic)

    It took 5 hours but worked. Kindof. Now I can’t get to the dashboard. It looks like my admin user has been changed to subscriber?????

    Plugin Author Yani

    (@yaniiliev)

    It’s set 120 seconds. I’m trying it again. Does the plugin have a timeout on the restore of the database?

    This setting will turn off any script that is processing for longer than 120seconds. That’s why you need to increase it. The plugin tries to process everything in pieces of 30 seconds each, however, some database tables cannot be split and need to be processed in one request – if this request takes more than the max_execution_time settings, you could experience the issue above.

    It took 5 hours but worked. Kindof. Now I can’t get to the dashboard. It looks like my admin user has been changed to subscriber?????

    Sounds like the database might have not been imported well. I’ve seen some plugins generate duplicate records for wp_roles and wp_capabilities.
    You will have to examine the database to see if your wp_roles and wp_capabilities do not have 2 entries.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import gets stuck after 40% of database restored’ is closed to new replies.