• Resolved Dierk

    (@dierk)


    For several months WPB2D worked fine but for the past couple of weeks I see something like this:

    22:23:56: SQL backup complete. Starting file backup.
    22:23:56: Creating SQL backup.
    22:23:39: There has been no backup activity for a long time. Attempting to resume the backup.
    22:18:02: SQL backup complete. Starting file backup.
    22:18:02: Creating SQL backup.
    22:17:59: There has been no backup activity for a long time. Attempting to resume the backup.
    22:12:06: SQL backup complete. Starting file backup.
    22:12:06: Creating SQL backup.
    22:11:07: There has been no backup activity for a long time. Attempting to resume the backup.
    22:03:39: SQL backup complete. Starting file backup.
    22:03:39: Creating SQL backup.
    22:03:36: There has been no backup activity for a long time. Attempting to resume the backup.
    21:53:38: SQL backup complete. Starting file backup.
    21:53:37: Creating SQL backup.
    21:53:34: Your time limit is 50000 seconds and your memory limit is 256M
    21:53:34: Backup started on Tuesday September 17, 2013.

    The backup starts, backs up the DB – I checked, they are in the appropriate folder in the WP-installation – and stalls when it comes to the files.

    I am not quite sure if it worked after the following two changes I made recently, but I think so [more below].

    Change 1: Originally my WP installation ran from the same folder it was installed to, a level 1 subfolder of my Web site’s root. In August I changed it to run from root but the installation stayed in the subfolder.

    Change 2: I updated from WP 3.6 to 3.6.1.

    I know the backup worked after change 1 as WPB2D started to fill my Dropbox with everything on my part of the server, that is the old static Web site, all of WP as well as a second CMS for photographic contents. I stopped that and checked all those folders WPB2D shall not process.

    https://www.ads-software.com/plugins/wordpress-backup-to-dropbox/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    Gday mate,

    I reckon this is because your database have become too large and the plugin is filing to dump it. I have re-engineered the DB dump in 1.7.

    Wanna try out the beta and see how it goes?

    https://dl.dropboxusercontent.com/u/3557067/wpb2d/wordpress-backup-to-dropbox.zip

    Cheers,
    Mikey

    Thread Starter Dierk

    (@dierk)

    Hello,

    I installed the beta version and it, too, started out fine [with a more detailed monitoring log output]:

    08:35:32: There has been no backup activity for a long time. Attempting to resume the backup.
    08:29:32: There has been no backup activity for a long time. Attempting to resume the backup.
    08:23:51: SQL backup complete. Starting file backup.
    08:23:51: Processed table ‘wp_wpb2d_processed_files’.
    08:23:51: Processed table ‘wp_wpb2d_processed_dbtables’.
    08:23:51: Processed table ‘wp_wpb2d_premium_extensions’.
    08:23:51: Processed table ‘wp_wpb2d_options’.
    08:23:51: Processed table ‘wp_wpb2d_excluded_files’.
    08:23:51: Processed table ‘wp_users’.
    08:23:51: Processed table ‘wp_usermeta’.
    08:23:51: Processed table ‘wp_terms’.
    08:23:51: Processed table ‘wp_term_taxonomy’.
    08:23:51: Processed table ‘wp_term_relationships’.
    08:23:51: Processed table ‘wp_ssp_galleries’.
    08:23:51: Processed table ‘wp_posts’.
    08:23:50: Processed table ‘wp_postmeta’.
    08:23:49: Processed table ‘wp_options’.
    08:23:47: Processed table ‘wp_nxs_log’.
    08:23:47: Processed table ‘wp_links_extrainfo’.

    As you see, after a few minutes it seemed to have timed out again.

    BTW, the files in the backup folder have file names like ‘db357713442-backup-plugins.sql.[long alphanumeric part, looking like hash value]-wpb2d-secret’; the log file, however, is fully readable in a text editor.

    The size of the SQL files [v1.6.1]: Core 3.1 MiB, Plugins 50.9 KiB.
    Size of the [consolidated?] SQL file [v 1.7]: 3.2 MiB.

    Lastly and for good measure, the automated backup is set to Monday morning, 5 a.m., should be a quiet, low-load time for the server.

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    Do you have any errors in your PHP error logs?

    Thread Starter Dierk

    (@dierk)

    Never got around to get a php-errors.log running. Tried again this morning but am obviously not competent enough to make the file visible to WP, that is, nothing gets written into it and a plugin to easily see the errors tells me the file cannot be found or is inaccessible.

    I used https://digwp.com/2009/07/monitor-php-errors-wordpress/, method one.

    Thread Starter Dierk

    (@dierk)

    Eventually got the error log working. I then started a manual backup, which resulted in the now familiar monitoring output [see above]. After about 20 Minutes and three ‘There has been no backup activity for a long time. Attempting to resume the backup.’ I stopped the process, taking a look at the PHP error log file. It’s empty, no errors.

    Thread Starter Dierk

    (@dierk)

    Further into the depths of finding what causes the non-backup …

    I switched of several Plugins I installed after the last working backup; didn’t change a thing. After that I switched on WP debugging, which did horrible things to my site but nothing lasting obviously. This way I got some PHP errors, none of which seems to have any [serious] consequences for my site.

    While debugging was on WPB2D was running and trying to back up, hence any problems should be noted. Alas, I cannot make heads or tails of it. If you want the error log, just tell me and I sent it.

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    Please send it to [email protected]

    Cheers,
    Mikey

    Hi, Michael. I am getting the same errors as Dierk:

    08:35:32: There has been no backup activity for a long time. Attempting to resume the backup.
    08:29:32: There has been no backup activity for a long time. Attempting to resume the backup.
    08:23:51: SQL backup complete. Starting file backup.
    08:23:51: Processed table ‘wp_wpb2d_processed_files….
    ETC

    I just updated from 0.9.2 to the latest version 1.7. Thanks for any help you can provide.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Backup starts and then times out’ is closed to new replies.