"No Database" listed for backup

  • Resolved cinman

    (@cinman)


    10 years, 7 months ago

    I am going to update WP from 3.5.1 to 3.6 and thought I’d make sure there was a recent backup using UpdateDraft. Looking at the backup sets available, I noticed that some showed “No Database”. I have run some tests with a manual backup to find “No Database” but the FTP files show database tables with a .gz extension in the backup folder.

    I do not have the “broken” W3 Total Cache plugin installed, however, I did deactivate all other plugins to then run a backup that did successfully complete with a valid DB backup.

    It appears in the FTP results that there is, in the end of a successful DB backup, only one final .gz file for the entire database. It would appear then that the backup process does a .gz backup of the tables individually, then combined those into one final .gz for the entire database that the plugin then calls good.

    I do not know which of my plugins may have effected the db backup and I dont have time to go through them all right now, but thought I’d see what your thoughts were on this.

    Thanks.

    http://wordpress.org/plugins/updraftplus/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author David Anderson

    (@davidanderson)

    10 years, 7 months ago

    Hi,

    Can you post the log file from the backup that shows “No database”? Use pastebin.com as it’ll be too big for this forum.

    Best wishes,
    David

    Thread Starter cinman

    (@cinman)

    10 years, 7 months ago

    http://pastebin.com/G5NLEp63
    Replaced actual server paths with /rootDir/

    Plugin Author David Anderson

    (@davidanderson)

    10 years, 7 months ago

    Hi cinman,

    There is indeed no database – it appears to halt every time it gets to the “cp_inman_posts” table.

    Do you know where to find your PHP error log? It’s often in wp-admin/error_log, or in the root of the site in a file called error_log. If neither of those, then ask your web hosting company. There’s likely to be an error logged in there that will tell us why it is halting.

    David

    Thread Starter cinman

    (@cinman)

    10 years, 7 months ago

    I added the logging script below to my php.ini file under wp-admin and added a plugin to read any errors, but nothing is showing for errors, nor is the file being created that I can see. I ran several other manual backups with the same results of No Database. My host is 1and1 if that means anything. I’m not sure if the php.ini is set correctly and in the correct spot to catch anything.

    error_reporting = 4339
    display_errors = Off
    display_startup_errors = Off
    log_errors = On
    error_log = /php_error.log
    log_errors_max_len = 1024
    ignore_repeated_errors = On
    ignore_repeated_source = Off
    html_errors = Off

    Thread Starter cinman

    (@cinman)

    10 years, 7 months ago

    More testing – again, I don’t know which plugin is causing the issue, but I can get a proper backup by deactivating all plugins prior to a backup. So, did so, and updated to WP 3.6. Tested again, same results.

    Plugin Author David Anderson

    (@davidanderson)

    10 years, 7 months ago

    Hi cinman,

    1) To test your PHP logging, upload a single PHP file with this in:

    <?php error_log('testing...'); ?>

    Then visit that file via a browser. If your logging is set up properly, then you’ll see “testing…” in the error log.

    2) If it’s another plugin, then try re-enabling them one-by-one until you find the culprit; i.e. a process of elimination. Do let me know the results!

    David

    Thread Starter cinman

    (@cinman)

    10 years, 7 months ago

    I finally was able to get error reporting to work. The only error that gets reported at all during the unsuccessful database backup, when all plugins are enabled is – below-

    [06-Sep-2013 04:45:34 UTC] PHP Fatal error: Out of memory (allocated 23855104) (tried to allocate 269817 bytes) in /root/blog/wp-content/plugins/updraftplus/backup.php on line 858

    Plugin Author David Anderson

    (@davidanderson)

    10 years, 7 months ago

    Hi,

    The error message indicates that your web hosting has PHP set up to allow a maximum of 22Mb of memory… that’s kind-of ‘off-the-scale’… in our stats, we’ve never come across anyone with less than 32Mb allowed (and only 0.2% had as low as 32Mb; a further 0.1% had as low as 48Mb; a further 1.9% had 64Mb; the typical value is 256Mb)… so you should definitely look into why it’s so low.

    David

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘"No Database" listed for backup’ is closed to new replies.