Cron task, mysqldump, add a password

[Old Nick]

Hello, this is the anacrontab i use to save my db:

1@daily 0 mysql_backup mkdir -p /srv/data/home/mysql_backup ; mysqldump -u root --all-databases | /bin/gzip -9 > /srv/data/home/mysql_backup/`date '+%F'`.databases.sql.gz ; find /srv/data/home/mysql_backup -name '*.databases.sql.gz' -mtime +7 -delete

I get error because there is no password indicated in the crontab

2024-07-07T00:05:47 mysql_backup: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

How can i edit the crontab to add my db password?
here is a fake password for the example : Xx123

Thanks.

 

[Paul B]

Add the password immediately after the -p .

 

[Old Nick]

Thanks, immediately means -pXx123 or -p Xx123 ?

 

[Paul B]

No space.

 

[Mouth]

How can i edit the crontab to add my db password?

You shouldn't do this, it's a security risk.

Do this instead ...

How to perform a mysqldump without a password prompt?

I would like to know the command to perform a mysqldump of a database without the prompt for the password. REASON: I would like to run a cron job, which takes a mysqldump of the database once every...

stackoverflow.com

 

[Old Nick]

Thanks @Mouth, i did that, will see if it works tonight at 0:00...

 

[Mouth]

Thanks @Mouth, i did that, will see if it works tonight at 0:00...

Did you make sure the .my.cnf went into the home dir of the user running the cron/mysqldump command, and the file is owned/readable by that user !?

 

[Old Nick]

I think so:

 

[Old Nick]

It works well.

 

[rdn]

You may want to try this one also:

GitHub - quickshiftin/mysqlbkup: Lightweight MySQL backup script in BASH

Lightweight MySQL backup script in BASH. Contribute to quickshiftin/mysqlbkup development by creating an account on GitHub.

github.com