0kb back up files, starting with last WP update

  • Resolved tgiokdi

    (@tgiokdi)


    6 years, 10 months ago

    All my backups are saving as 0kb files, with successful backup messages being displayed, no errors. this happened after the last WP update.

    Database Backed Up Successfully On 'May 5, 2018 @ 8:26 pm'.

Checking Security Status
.htaccess is present in /wordpress/wp-content/backup-db

index.php is present in /wordpress/wp-content/backup-db

Checking Backup Status
Checking Backup Folder (/wordpress/wp-content/backup-db) ...
Backup folder exists

Backup folder is writable

Checking MYSQL Dump Path (/usr/bin/mysqldump) ...

MYSQL dump path exists.

Checking MYSQL Path (/usr/bin/mysql) ...

MYSQL path exists.

Checking PHP Functions (passthru(), system() and exec()) ...
passthru() enabled.

system() enabled.

exec() enabled.

Excellent. You Are Good To Go.

    I’ve recently reduced the size of database and it was running fine at the previous 10 gb unzipped, so I’m not sure why it’s suddenly failing without errors on a leaner database.

    help?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Lester Chan

    (@gamerz)

    You probably have to check your logs. My guess, is that PHP timed out because 10GB of file is huge and it takes time.

    Thread Starter tgiokdi

    (@tgiokdi)

    what logs would I be looking at? the file is created nearly immediately, so there’s no timing out. in the past it would take 30-45 seconds with the larger database.

    Plugin Author Lester Chan

    (@gamerz)

    Your PHP logs/ Alternatively, you can try to reproduce the problem https://www.ads-software.com/plugins/wp-dbmanager/#faq first question.

    Thread Starter tgiokdi

    (@tgiokdi)

    nothing in the php logs, but taking the first FAQ question did the trick, it returned this error:

    mysqldump: unknown variable 'table_open_cache=600'

    Commenting out the table_open_cache=600 portion of my mysql config allowed the backups to continue.

    I was under the impression that the table_open_cache was still a valid variable for mysql configurations.

    Thanks for your help, I appreciate it.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘0kb back up files, starting with last WP update’ is closed to new replies.