MySQL backups too big

[Guillermo]

When directadmin makes a backup of my mysql databases, it makes a full mysql backup called full-mysql.tar.gz, and also makes a seperate mysql backup of each database. So in fact, it's being backupped twice, and taking a lot of extra diskspace.
I don't want the backup to create the full-mysql.tar.gz file. How do i fix that?

[chatwizrd]

You can edit /usr/local/sysbk/mod/mysql.bk

[Guillermo]

Is there any other way to do it?

I have a better idea. What if the system replaces the second last backup every day, so there will only be two backups on the disk.
This will save diskspace, and i won;t have to delete the old backups manually anymore.

How can i fix that?

[chatwizrd]

Why not just uncheck mysql user backups and just backup the directory that mysql uses.

[Guillermo]

Originally posted by chatwizrd
Why not just uncheck mysql user backups and just backup the directory that mysql uses.

Yeah i thought about that. But it's better that the cronjob deletes the second last backup, and replaces it with a new one.

[chatwizrd]

Originally posted by Guillermo
Yeah i thought about that. But it's better that the cronjob deletes the second last backup, and replaces it with a new one.

Well you would need to edit the backup system located in /usr/local/sysbk

Its an old program and needs updating bigtime. I have thought about rewriting it myself but dont really have the time.

[Guillermo]

Originally posted by chatwizrd
Well you would need to edit the backup system located in /usr/local/sysbk

Its an old program and needs updating bigtime. I have thought about rewriting it myself but dont really have the time.

I see, isn't it possible to perform such an operation by cron? Otherwise i'll ask my coder to edit the backup system.

[chatwizrd]

Yeah but it wouldnt be using sysbk. You can always write your own shell scripts and set them up via cron.