Restore failed. Sql file importing time out.

  • Resolved robooooooo

    (@robooooooo)


    4 months, 2 weeks ago

    Hello!
    I made a backup with the free version, which went well, and I tried to restore the site, but I got this error at the very end of the restoration: “Restore failed. SQL file importing timeout.”
    The process goes quickly up to 83%, then slowly advances to 99% and takes 30 minutes (new line every 5 minutes) until this message appears: “Restore failed. Sql file importing time out.”
    Thanks for your help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support tonyrobins

    (@tonyrobins)

    4 months, 2 weeks ago

    Hello @robooooooo

    The timeout you are experiencing at the 99% mark usually indicates that the server is struggling to finalize the database import, often due to memory constraints or database packet size limits.

    To resolve this, please try the following adjustments:

    1. Go to the WPvivid plugin menu > Settings > Advanced Settings. Locate the PHP Memory Limit for restoration and increase it to 1024MB or 2048MB (to be higher than the total size of your database).
    2. Increase the max_allowed_packet setting for your MySQL/MariaDB database to 32MB or 64MB if possible. This allows the server to handle larger chunks of data during the final stages of the import.

    Once these changes are applied, please attempt the restoration again and let us know how it goes.

    All the best,

    Thread Starter robooooooo

    (@robooooooo)

    4 months, 2 weeks ago

    Hello Tony,

    Perfect, the solution 1 was enough 🙂

    Thanks a lot for your precious and fast help !!

    Have a nice day!

    Thread Starter robooooooo

    (@robooooooo)

    4 months, 2 weeks ago

    I mark it as resolved 🙂 Thanks

    Plugin Support tonyrobins

    (@tonyrobins)

    4 months, 2 weeks ago

    Hello @robooooooo

    You are welcome and glad it worked. Please feel free to let us know if you have any issues using WPvivid in the future.

    All the best,

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.