WordPress.org

Ready to get started?Download WordPress

Forums

Online Backup for WordPress
[resolved] Database backup problem (4 posts)

  1. cobungra
    Member
    Posted 2 years ago #

    This works fine on my test server, but fails on the host.
    Files backups work, but this error shows with a full or database backup.

    A filesystem operation failed while processing 'Database/OBFW_Database.sql' for backup.
    If the following error message is not clear as to the problem and the issue persists, please contact support providing the complete event log for the activity. Diagnostic information follows:

    Failed at: 300(/host/hostsub/something/sitename/public/www/web/wp-content/plugins/wponlinebackup/include/tables.php)
    An error happened at: compressor_deflate.php(304)
    gzopen(/tmp/obfwq1qKII) [function.gzopen]: failed to open stream: Operation not permitted

    Can someone suggest what might be going on?
    Thanks

    http://wordpress.org/extend/plugins/wponlinebackup/

  2. Online Backup
    Member
    Plugin Author

    Posted 2 years ago #

    Hi cobungra,

    The host has a bad configuration - the temp directory it is exposing is not accessible. But with a few steps you can create your own.

    Create a folder using FTP that is not visible on your website, so next to public_html instead of inside it, if you have that folder. Or create the folder anywhere and use your control panel to password protect it.

    Then go to General Settings and look at the text next to Filesystem excludes, it will say something like this:
    Custom filesystem excludes can be specified here, one per line, relative to the following folder: /var/www/homes/user/public_html
    This is the absolute path to your WordPress website. You can use this to work out the absolute path to the folder you just created as you will need it.

    Next, look in the address bar of your browser where it says: wp-admin/tools.php?page=wponlinebackup%2Fwponlinebackup.php&section=settings
    Change the end to advanced, so it says: wp-admin/tools.php?page=wponlinebackup%2Fwponlinebackup.php&section=advanced
    This will load the hidden advanced settings page - be careful not to change anything here unless you understand it as it can break the plugin, thus why it is hidden.

    On this page, look for gzip_tmp_dir and tick the checkbox and change the path to the folder you created - it needs to be absolute path and you need to tick the box or it will ignore the new value - ticking it means to override it. Click Save and it should apply.

    Try running a backup then.

    Jason.

  3. cobungra
    Member
    Posted 2 years ago #

    Terrific.
    Thanks very much Driskell this all made sense and has solved the problem.
    The plugin is working well now (WP 3.3.1)
    Kind regards.

  4. zubir2k
    Member
    Posted 2 years ago #

    Thank you so much!

    I had the same issue and manage to resolve the problem by following your guide.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic