Admin Backup failes on mysql

Z

ZipperZapper

Verified User
Joined
Nov 30, 2015
Messages
142
This weekend I upgraded my server from Ubuntu 14.04 (EOL) tot Ubuntu 16.04.
All seems to be working quite fine, apart from the scheduled Admin Backup.

It throws up this error for all users/databases:

Code: 
Error while backing up database XXXX
Error while backing up database XXXX: The sql file is 0 bytes in size: /home/tmp/XX.3892/XX/backup/XXXX.sql
mysqldump error output: mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" when trying to connect

And in the end:

Code: 
Error Compressing the backup file /home/tmp/XX.3892/XX/backup/home.tar.gz : /bin/tar: backup: Function open() failed: permission denied
/bin/tar: Stopped due to earlier errors

A search on the forum showed me this topic with the same problem.

I checked the location:
Code: 
- locate mysql.sock
>> /home/mysql/mysql.sock

This confirms the "/tmp/mysql.sock" the backup process is trying to use isn't the right one.

Then I checked /etc/my.cnf and it only contains the following three lines:

Code: 
[mysqld]
local-infile=0
innodb_file_per_table

I added "socket = /home/mysql/mysql.sock" to it and rebooted the server, but the backup process still throws up the same error.

Can anyone point me in the right direction here?
 
Do you mean I have to check there?

/var/lib/mysql doesn't exist.

I have to add mysql itself seems to work fine, Wordpress sites work fine, I can post new entries, PHPMyAdmin works.

It's just the Admin Backup that throws up errors with mysql.
 
I found out Lets Encrypt wasn't working and Dovecot acted a bit weird.
I ended up reverting back to my snapshot with Ubuntu 14.04.

It looks like it's just simply impossible to upgrade from Ubuntu 14.04 LTS to Ubuntu 16.04 LTS with a 'do-release-upgrade' without breaking everything Directadmin-related.
 
You must log in or register to reply here.
Back
Top