mysqldump: Got errno 28 on write Error backing up MySQL data

[peakyblinder]

Hi,

Trying to upgrade to the latest version of Nagios XI and keep receiving the error message "mysqldump: Got errno 28 on write
Error backing up MySQL database 'nagios' - check the password in this script!"

From what I can gather, its not a password/script issue, its a problem saving the MySQL backup?
Running df- h tells me that nothing is short of space, although I'm not sure which filesystem would be the one its trying to save to. Maybe the DB is too big to be saved - how can I tell?

Thanks,

[scottwilkerson]

Maybe the DB is too big to be saved - how can I tell?

It is an amount of free space on the server thing. I know it may look like you have a log of space but a database dump to backup the DB before upgrade take a considerable amount of space. Can you share your

Code: Select all

df -h

[peakyblinder]

True... My DB must be pretty big then...

Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_master-lv_root 22G 2.9G 19G 14% /
devtmpfs 1.9G 0 1.9G 0% /dev
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 1.9G 201M 1.7G 11% /run
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/sda1 997M 196M 802M 20% /boot
/dev/mapper/vg_master-lv_var_log 4.0G 631M 3.4G 16% /var/log
/dev/mapper/vg_master-lv_var_lib_mysql 4.0G 815M 3.2G 20% /var/lib/mysql
/dev/mapper/vg_master-lv_store 4.0G 1.7G 2.4G 42% /store
/dev/mapper/vg_master-lv_usr_local 16G 4.2G 12G 26% /usr/local
/dev/mapper/vg_master-lv_tmp 4.0G 33M 4.0G 1% /tmp
tmpfs 378M 0 378M 0% /run/user/1000
tmpfs 378M 0 378M 0% /run/user/186000542
tmpfs 378M 0 378M 0% /run/user/186000541

[scottwilkerson]

For sure this is not large enough

Code: Select all

/dev/mapper/vg_master-lv_store 4.0G 1.7G 2.4G 42% /store