Comments on Creating MySQL Backups With AutoMySQLBackup

Hi,
Thanks for the explanation. The script is working pretty fine for me.
I find very useful to change the option LATEST to yes.
This way creates a separated directory with the latest copy of each database. Very handy when it comes the time to search where is latest backup is stored.

Thanks for the info. Changing the file permissions  to 711 rather than 755 on the automysqlbackup.sh.2.5 file would be more secure as this file is holding secure info (your root mySQL user and pass). Set as 711 any user on the system could view the file and gain root access to your mySQL databases.

Cheers

When I upload the file to my var/www/ folder and chmod 755 I still can not get this script to work I get a -bash automysqlbackup.sh.2.5 command not found ??

I have a basic unbuntu LAMP server setup

thanks for any help 

Does anybody know something about a backup software for MySQL named Handy Backup?

I`m very interested in the tool.  

Thanks again.

Thanks for this simple tutorial on this great tool. Works wonders!

Nice article.

For backing up large databases with mysqldump there is a nice script that split up the files by table.

http://moinne.com/blog/ronald/mysql/backup-large-databases-with-mysqldump

For really large databases that cannot be taken offline, you need another method...

/Emma.

I can run the automysqlbackup using sudo, but when run without it I get an 'find: '/var/lib/mysql' : Permission denied' error

I'm using Ubuntu, any idea what I'm doing wrong?

It was really easy to implement and works pretty well.

I want to know if you can recomend an online service for backups to be able to upload the backed file.

also if there is a way to limit the amount of backed files to X number like 2 on the monthly 5 on the weekly and 7 on the daily so the hard drive does not get full of backups.

with a 2.4Gb database 250MB after compress it's important to be carefull and not run out of space so have it to clean the previous file lets say it runs today monday 7 so delete the previous Monday 1 and so

thanks for this great scrigt. :)