Unable to do database backup

  • Resolved fberzau

    (@fberzau)


    9 years ago

    I get Warnings during the full back or database only backup like:

    1. Try to backup database …
    Connected to database mydb on myserver
    WARNING: Job restarts due to inactivity for more than 5 minutes.
    2. Try to backup database …
    Connected to database mydb on myserver
    WARNING: Job restarts due to inactivity for more than 5 minutes.
    2. Try to backup database …
    Connected to database mydb on myserver
    WARNING: Job restarts due to inactivity for more than 5 minutes.
    2. Try to backup database …
    Connected to database mydb on myserver
    WARNING: Job restarts due to inactivity for more than 5 minutes.

    This goes on several more times until about 3 hours after the job started. Then I get:

    3. Try to backup database …
    Connected to database mydb on myserver
    ERROR: Error while writing file!
    ERROR: Step aborted: too many attempts!

    A manual database download works though, the downloaded file is roughly 110 MB in size.

    The total backup is zipped and uploaded to Dropbox. It’s about 750 MB in size.

    https://www.ads-software.com/plugins/backwpup/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter fberzau

    (@fberzau)

    Meanwhilte… I created a new job which does a database backup only. It was running since yesterday, and I have now manually stopped it. Same warnings as in the full backups.

    Any help?

    Daniel Hüsken

    (@danielhuesken)

    If there more messages between:

    Connected to database mydb on myserver
    WARNING: Job restarts due to inactivity for more than 5 minutes.

    Did you have a Caching Plugin installed?
    Hoster, Webserver and PHP Softawre will be helpfull informations.

    Thread Starter fberzau

    (@fberzau)

    There are no more messages in between. The above is – except anonymizing the db and server names – an actual snippet of the log. Those three lines repeat several times, the entire job runs for hours.
    There is no caching plugin enabled.
    The hoster is 1&1.
    Webserver is Apache.
    PHP Version 5.4.45.

    Daniel Hüsken

    (@danielhuesken)

    Oh, 1&1 is a very restrictive hoster.
    You can try to Set up maximium Execution time in BAckWPup > Settings > Tab: Job. begin with a value of 30 secounds.

    Thread Starter fberzau

    (@fberzau)

    I made two changes:

    1) A server side PHP setting, by creating a php.ini in the wordpress root folder with the following line: “max_execution_time=30”
    2) Setting “Maximum Execution Time” to 25 in the BackWPup settings as per previous suggestion

    The combination of both completely fixed the issue.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Unable to do database backup’ is closed to new replies.