Wordpress Backup error message

[nedalper]

I am using the BackUpWordPress plugin on a Sonic site, and I am receiving the following error message:

Mysqldump: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have a similar setup on another Sonic site, with no such problem.

Any ideas or recommendations? Appreciate the help!

[joemuller]

You might be defaulting to an older version of PHP - make sure you're using at least 5.3 as outlined on the Wiki:
[link]https://wiki.sonic.net/wiki/Php5[/link]

Please feel free to send further information (site, directory) to me via a private message if it still isn't working right.

[nedalper]

Hi Joe:

To the best of my knowledge, we have PHP 5.3.29 and MSQL 5.5.47

The BackUpWordpress plugin is not my favorite, but it does backup on a set schedule but for the error message. I prefer to use UpdraftPlus, but there are usually Cron issues and scheduled backups have been a problem.

Thanks, Ned

[drew.phillips]

Hi Ned,

You're correct on the versions but as it turns out, all PHP versions are linked against older MySQL client libraries (version 5.0.67) which is why you are getting that error. This essentially means PHP only knows how to speak to MySQL 5.0 servers and isn't aware of features & functionality offered by newer versions such as the newer hashed passwords (you can still of course issue queries that use newer features). Since it is referencing the "mysqldump" program, the same applies for that.

I checked and shell.sonic.net is also running MySQL client 5.0 so you might have some trouble trying manually from there too.

We're looking into getting MySQL libraries updated for PHP so stay tuned and thank you for the feedback.

Drew

[Guest]

The BackUpWordpress plugin is not my favorite, but it does backup on a set schedule but for the error message. I prefer to use UpdraftPlus, but there are usually Cron issues and scheduled backups have been a problem.

You may want to look at https://wordpress.org/plugins/backwpup/ - I use it on several sites. It will back up database only, or database and files, and you specify the directories and folders you want backed up. You can set a schedule (I typically run weekly database and monthly full site backups), and send the backup files to DropBox, S3, Rackspace, email, FTP - it's a pretty robust backup plugin with a free and a premium version.

[nedalper]

Hi Guest:

Thanks for the recommendation -- I have installed this on both of my Sonic sites, backed up each, and we'll see how it operates on a schedule...

Thanks, Ned

[nedalper]

Hi:

I have been getting the following error messages on backup with BackWPup:

[INFO] BackWPup 3.3; A project of Inpsyde GmbH
[INFO] Log Level: Normal
[INFO] BackWPup job: Soldata backup
[INFO] Logfile is: backwpup_log_c20451_2016-04-25_12-53-56.html
[INFO] Backup file is: backwpup_c20451_2016-04-25_12-53-56.zip
[25-Apr-2016 12:53:56] 1. Try to backup database …
[25-Apr-2016 12:53:56] Connected to database soldata_oc_1 on b.custsql.sonic.net
[25-Apr-2016 12:53:56] Added database dump "soldata_oc_1.sql" with 3.68 MB to backup file list
[25-Apr-2016 12:53:56] Database backup done!
[25-Apr-2016 12:53:56] 1. Trying to make a list of folders to back up …
[25-Apr-2016 12:54:04] Added "wp-config.php" to backup file list
[25-Apr-2016 12:54:04] 153 folders to backup.
[25-Apr-2016 12:54:06] 1. Trying to generate a file with installed plugin names …
[25-Apr-2016 12:54:06] Added plugin list file "SOLDATA-ENERGY-CONSULTING.pluginlist.2016-04-25.txt" with 2.19 kB to backup file list.
[25-Apr-2016 12:54:06] 1. Trying to generate a manifest file …
[25-Apr-2016 12:54:06] Added manifest.json file with to backup file list.
[25-Apr-2016 12:54:06] 1. Trying to create backup archive …
[25-Apr-2016 12:54:06] Compressing files as ZipArchive. Please be patient, this may take a moment.
[25-Apr-2016 12:56:48] ERROR: ZipArchive returns status: Closing zip archive failed: Disk quota exceeded
[25-Apr-2016 12:56:48] ERROR: ZIP archive cannot be closed correctly

Any idea how to fix?

Thanks, Ned

[drew.phillips]

It looks like in your wordpress/wp-content/uploads/backwpup-cXXXXX-backups directory are a number of backups from previous days, some failed that are each about 2 GB and in total are taking up 20 GB of disk space, which is causing you to exceed your disk quota.

Try deleting some of these older backups. Since each backup is around 2 GB, if this plugin has any backup retention options, you may need to tell it to keep less backups.

[nedalper]

Thanks Drew -- I dumped a bunch of old backups and am trying again.

Regards, Ned