Comments on Set Up Rsnapshot, Archiving Of Snapshots And Backup Of MySQL Databases On Debian

Set Up Rsnapshot, Archiving Of Snapshots And Backup Of MySQL Databases On Debian This howto will show you how to install and set up Rsnapshot, enable archiving of snapshots and how to back up MySQL databases on Debian.

4 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Shane

Thanks for the awesome tutorial! I seem to get issues with hard links because my server is setup wtih enfcs ... have you experience that before? I cannot for the life of me figure out how to resolve that?

By: marcnz

the mysql dump rsnapshot entry is wrong. When entered as is, the configtest run fails.

1. There should be no spaces, but only tabs between the segments

2. The last "/" is missing at the end of mysqldump.

There is nothing more annoying than going through short tutorials like this and it is not workign because of the author can't write correct statements! Unless that author does it on purpose to force users to think and find solutions on their own.

Please correct it.

By: till

Thank you for the notice. The tutorial has been updated.

By: Poliman

In my backup, after execute command rsnapshot hourly, I get error below and file "mysqldump_all_databases.sql" is empty:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

I use /root/.my.cnf file:

 [mysqld] user     = root password = my_pass host     = localhost

When I change [mysqld] to [client] I haven't error but .sql file is still empty.