mysql backups in /store/backups/mysql/*

[Shawn L]

Hi,

I saw there were lots of backups in /store/backups/mysql/ directory. Since we have very limited space in the /store/, we would like to clean up that directory. Is there a way we can change the path for those backups?

Thanks.

[Shawn L]

I looked into that directory. the backups usually as small as 100+MB. But yesterday, it created a backup more than 2 GB. Does anyone know what could cause this problem?

Thanks.

[lmiltchev]

I saw there were lots of backups in /store/backups/mysql/ directory. Since we have very limited space in the /store/, we would like to clean up that directory. Is there a way we can change the path for those backups?

These backups are created by the "/root/scripts/automysqlbackup" script, which is run on a cron.

Code: Select all

grep auto /etc/cron.d/nagiosxi

You can open the "automysqlbackup" in a text editor, and change the backup directory path.

Code: Select all

# Backup directory location e.g /backups
BACKUPDIR="/path/to/your/new/backup/directory"

the backups usually as small as 100+MB. But yesterday, it created a backup more than 2 GB. Does anyone know what could cause this problem?

Do you see any errors in the mysqld.log? How much hard disk space do you have?

Code: Select all

df -h

[Shawn L]

Thank you for the help. The issue was resolved. I guess the reason was that we removed a script. Keep calling that script generated a lot of errors which filled out the database.

[rkennedy]

Ah, great to see it resolved!

Going to close this out now.