Unable to Create DB Backup

  • Resolved Jennifer

    (@ratgurrl)


    4 years, 4 months ago

    I have done a brand new clean installation using the most recent download of WordPress and the AIO plugin to try to troubleshoot this, but I’m still having issues. I have WP installed in a directory, and not in the root of the domain.

    Here is my process:

    Manual clean/default installation of WP and AIO Plugin — no other plugins (except for Akismet) are activated. No multi-site settings – just a single site setup. This is hosted on my own server (not a hosting company), so I have full control.

    In order to do the initial setup of the AIO WP Security, I manually change the permissions to 666 on .htaccess and wp-config.php to make all the settings updates/changes I’d like from the admin panel. After making the changes, I set .htaccess and wp-config.php back to 644/440, respectively. The setup will not work without doing this — assuming this is intentional for security purposes?

    Note: Even with the wp-config.php set to 755 or 777 (temporarily), I’m unable to disable the PHP file editing, and had to add “define(‘DISALLOW_FILE_EDIT’, true);” manually to that file.

    I am able to do a backup of the wp-config.php file from the settings tab (it prompts to save to my computer). However, I get an error “htaccess backup failed.” when trying to backup .htaccess. This is not a big deal since I can back them up via FTP if/as needed.

    My biggest issue is that I am not able to do a DB Backup. I get the following error: “DB Backup failed. Please check the permissions of the backup directory.”

    All of my permissions are set correctly. All files/folders are set to 644/755, respectively, with the exception of wp-config.php which is set to 440.

    Note: I did tried “hardening” my site per WordPress recommendations 640 for files and 750 for folders, but it broke the site; so I’m using 644/755 defaults for everything except for the wp-config.

    What have I missed??

    Jennifer

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi Jennifer,

    My biggest issue is that I am not able to do a DB Backup. I get the following error: “DB Backup failed. Please check the permissions of the backup directory.”

    It does sound like a file/folder permission issue. If you can’t workout why this is happening, I suggest that you contact your host. I have tested this feature myself, both the manual and automatic database backup and it works for me.

    Also make sure there are no plugin conflicts in your site. You might also like to check your site’s health with the following plugin.

    https://www.ads-software.com/plugins/health-check/

    Let me know if the above helps you.

    Thank you

    Thread Starter Jennifer

    (@ratgurrl)

    Thanks for the reply. I’m running this myself on my own server, so I am my own host ??

    The only plug-in I have enabled is the Akismet as this is a fresh install to troubleshoot/replicate the issue I was having on the live site.

    I’ll try turning that off, since I haven’t done that yet.

    I’m baffled as to how there could be a permissions error, since I’ve checked everything multiple times (and have reinstalled the entire WordPress installation from scratch 3 times).

    It makes no sense! I’v used previous versions of this plugin/Wordpress without issue. If anyone has any ideas at all, I would be most grateful for suggestions.

    I’m going to try a 100% clean install once more. ????

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Did you install the health check plugin I suggested above? What type of server is your site hosted in?

    Thank you

    Thread Starter Jennifer

    (@ratgurrl)

    I will try the health plugin you recommended and will report back with any additional info. Thank you!

    I’m running a QNAP NAS and have had it for about 7 years. No issues.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, how are you trailing with your issue?

    Thank you

    Thread Starter Jennifer

    (@ratgurrl)

    Hi! Thanks for checking in. Due to the holiday, I haven’t had an opportunity to futz with it further. I’m taking another look at it this evening and will follow up!

    Thread Starter Jennifer

    (@ratgurrl)

    I just did a brand new clean installation of WordPress and the AIO plugin. AOI is the only plugin enabled, and there are no other plugins or themes installed/activated. I’m still getting the same error(s).

    I tried installing as mydomain.tld/wordpress, and also in the root of mydomain.tdl

    Cannot backup .htaccess file
    Cannot backup database

    All folders are set to 755 and all files are set to 644

    Running WP 5.5.3
    AIO 4.4.4

    Jen

    Thread Starter Jennifer

    (@ratgurrl)

    Running the health check plugin now.

    Thread Starter Jennifer

    (@ratgurrl)

    There are 3 critical errors found:

    Error #1: I have FTP disabled on my server and use only SSH

    Background updates are not working as expected Security
    Background updates ensure that WordPress can auto-update if a security update is released for the version you are currently using.

    Warning Could not confirm that the wp_version_check() filter is available.
    Passed No version control systems were detected.
    Error Your installation of WordPress prompts for FTP credentials to perform updates. (Your site is performing updates over FTP due to file ownership. Talk to your hosting company.)

    Error# 2:

    The REST API encountered an error Performance
    The REST API is one way WordPress, and other applications, communicate with the server. One example is the block editor screen, which relies on this to display, and save, your posts and pages.

    The REST API request failed due to an error.
    Error: [] cURL error 60: SSL certificate problem: unable to get local issuer certificate

    Error #3:

    Your site could not complete a loopback request Performance
    Loopback requests are used to run scheduled events, and are also used by the built-in editors for themes and plugins to verify code stability.

    The loopback request to your site failed, this means features relying on them are not currently working as expected.
    Error encountered: (0) cURL error 60: SSL certificate problem: unable to get local issuer certificate

    Need to update my php.ini file with th CA to get rid of the Curl error, but otherwise nothing that looks related to file/folder permissions.

    *scratching head*

    Thread Starter Jennifer

    (@ratgurrl)

    I’m going to give up, and just do manual backups if/as needed. However, I’m Happy to do more troubleshooting if it will be helpful.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi,

    I’m going to give up, and just do manual backups if/as needed.

    That makes sense as long as manual backups works for you and you are happy with it.

    However, I’m Happy to do more troubleshooting if it will be helpful.

    You can if you want to. I am also curious to know why it is not working in your site? There are thousands of users running automatic backups on different servers without any issues. I believe this has something to do with your server settings, in my humble opinion.

    Kind regards

    Thread Starter Jennifer

    (@ratgurrl)

    I figured it out.

    I had to manually create a folder called “aiowps_backups” in the wp-content folder, then chmod to 777 — I was then able to do a backup.

    I looked at a backup of an old install from 2019 and saw that I had that folder created in the install. Since it seems to require 777 permissions, I’m going to make a symlink to a directory outside of my webroot.

    It must be something with how the server is setup — possibly ownership of the directories (owned by my user from manual upload, rather than httpd user, perhaps).

    Thanks for your assistance and suggestions.

    Jen

    Plugin Contributor mbrsolution

    (@mbrsolution)

    That is great news. I am happy to know you worked out the issue ??

    If your issue is resolved, you can mark this support thread as resolved.

    Thank you

    Thread Starter Jennifer

    (@ratgurrl)

    Thank you! ??

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Unable to Create DB Backup’ is closed to new replies.