Backup questions - mysql.sock: socket ignored

privard

Member
Aug 10, 2013
6
0
1
cPanel Access Level
Root Administrator
2 simple questions, but I've been looking hard and long on Google.

First question is: Why is it always written this when I receive the "backup complete" email from cPanel using the new backup system:
/bin/gtar: /var/lib/mysql/mysql.sock: socket ignored

Second, my back is being done at 2am EDT, but even though the server is most likely empty (I do not get a lot of visitors during the day, so it's even quieter at night), I get the following error when backing up MySQL. What is the ibdata1 file? Please bare in mind that this is a second server, and it's not related to the above server in question 1.

/bin/gtar: /var/lib/mysql/ibdata1: file changed as we read it
/bin/gtar: /var/lib/mysql/mysql.sock: socket ignored
[backup] Failed to perform full MySQL database backup

Thank you!
 

Aaron.Edwards

Active Member
Sep 21, 2013
36
0
6
cPanel Access Level
Root Administrator
First question is: Why is it always written this when I receive the "backup complete" email from cPanel using the new backup system:
/bin/gtar: /var/lib/mysql/mysql.sock: socket ignored
The MySQL socket error should be ignored as you cannot copy the socket file.

What is ibdata1 ?

Two important disk-based resources managed by the InnoDB storage engine are its tablespace data files and its log files. If you specify no InnoDB configuration options, MySQL creates an auto-extending data file, slightly larger than 10MB, named ibdata1 and two log files named ib_logfile0 and ib_logfile1 in the MySQL data directory. Their size is given by the size of the innodb_log_file_size system variable

MySQL :: MySQL 5.0 Reference Manual :: 14.2.1 Configuring InnoDB
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

It's normal for the socket file to be ignored. If you see "file changed as we read it", it indicates the database was not backed up due to MySQL activity during the backup process. Try checking the /etc/my.cnf file and see if the issue persists with an empty MySQL configuration file.

Thank you.
 

mrishadali

Registered
Apr 23, 2012
3
0
51
cPanel Access Level
Root Administrator
Hi I am having the same problem, I am getting a "[backup] Backup complete on server" email with the following log

[backup] Detected /mnt/back-up in /etc/fstab
[backupmount] Setting up mount
[backupmount] running: /bin/mount /mnt/back-up
[backupmount] running: /bin/mount -o remount,rw /mnt/back-up
[backup] Mount found (remote/location on /mnt/back-up type nfs (rw,tcp,intr,rsize=8192,wsize=8192))
/bin/gtar: Removing leading `/' from member names
/bin/gtar: /var/lib/mysql/ibdata1: file changed as we read it
/bin/gtar: /var/lib/mysql/mysql.sock: socket ignored
[backup] Failed to perform full MySQL database backup
gzip: /mnt/back-up/2013-11-05/system/files/_etc_shadow: Permission denied
[backup] Failed to compress file /mnt/back-up/2013-11-05/system/files/_etc_shadow
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from hard link targets
/bin/gtar: /var/cpanel/dnsadmin/sock: socket ignored
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
[backup] System backups will not be uploaded to any remote destinations
The problelm is, there is alway MYSQL activity on the server because there are some applications running which use MYSQL database every minute.
Do I have to stop those applications when the backup process is running? Can you help me with this?

Thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
The problelm is, there is alway MYSQL activity on the server because there are some applications running which use MYSQL database every minute.
Do I have to stop those applications when the backup process is running? Can you help me with this?
The MySQL databases are still backed up through the "mysqldump" utility if you have databases backed up per account. The entire MySQL directory is what's failing to backup. You may want to disable the backup for the entire MySQL directory if you have database activity at all times.

Thank you.
 

mrishadali

Registered
Apr 23, 2012
3
0
51
cPanel Access Level
Root Administrator
Thank you very much for your reply.
today I got the following error
[backup] Detected /mnt/back-up in /etc/fstab
[backupmount] Setting up mount
[backupmount] running: /bin/mount /mnt/back-up
[backupmount] running: /bin/mount -o remount,rw /mnt/back-up
[backup] Mount found (remote/location on /mnt/back-up type nfs (rw,tcp,intr,rsize=8192,wsize=8192))
/bin/gtar: Removing leading `/' from member names
/bin/gtar: /var/lib/mysql/mysql.sock: socket ignored
gzip: /mnt/back-up/2013-11-06/system/files/_etc_shadow: Permission denied
[backup] Failed to compress file /mnt/back-up/2013-11-06/system/files/_etc_shadow
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from hard link targets
/bin/gtar: /var/cpanel/dnsadmin/sock: socket ignored
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
/bin/gtar: Removing leading `/' from member names
[backup] System backups will not be uploaded to any remote destinations
[backup] pruning backup directory: /mnt/back-up/2013-11-01
gzip could not compress files. How do I fix this error?

Thank you
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
It looks like the "Permission denied" error may be related to the backup mount. Is the NFS mount configured with any special permissions or ownership restrictions? Do you get the same error if you try backing up to a local directory that's not a NFS mount?

Thank you.