Page 1 of 1
mysql backups in /store/backups/mysql/*
Posted: Mon Apr 18, 2016 9:29 am
by 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.
Re: mysql backups in /store/backups/mysql/*
Posted: Mon Apr 18, 2016 9:45 am
by 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.
Re: mysql backups in /store/backups/mysql/*
Posted: Mon Apr 18, 2016 12:23 pm
by 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.
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?
Re: mysql backups in /store/backups/mysql/*
Posted: Thu Apr 21, 2016 2:56 pm
by 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.
Re: mysql backups in /store/backups/mysql/*
Posted: Thu Apr 21, 2016 3:06 pm
by rkennedy
Ah, great to see it resolved!
Going to close this out now.