3 replies to this topic

[zaphe87]

I'm not sure if this is the right category for this, i couldn't see a better titled one..

I am trying to set up a cron job to automatically backup my mysql databases. After viewing many examples and tutorials i finally managed to get beyond the point of it rejecting my command or failing to connect, this is what i had:

With my password/username, etc... ***'d out

nice -n 15 /usr/bin/mysqldump --opt -u *** -p*** ¦ gzip > /home/***/backups/mysqlbackup_`date +\%d\%m\%y`.sql.gz

And i got this response from the automated email:

mysqldump: Got error: 1044: Access denied for user '***r'@'localhost' to database '?' when selecting the database


So i tried adding --all-databases to it, but wasn't sure where to put it, ended up with this:

nice -n 15 /usr/bin/mysqldump --opt -u *** -p*** --all-databases ¦ gzip > /home/***/backups/mysqlbackup_`date +\%d\%m\%y`.sql.gz

But now it doesn't seem to be running, as i'm not getting the email.

Could anyone tell me where i'm going wrong? Thanks.

[zaphe87]

The username and password are correct, it just don't know where to tell it which databases to dump.