Docker Exec Backup Error 1045

[BobCumberbatch]

Hi Jan,
I run part-db in a container in a local raspberry pi5 with MySQL. I have been running this command to perform a back up. I am running Version: 2.12.0

BACKUP Docker Exec command I have used successfully until now
docker exec mysql-container sh -c 'mysqldump -u root -pYourPassword dbname' > dump.sql

I now get this error:

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

Are you able to advise how I need to change this command to get backup to run successfully please?

Thanks, Bob

[d-buchmann]

Your password doesn't seem to be seen by mysql, hence the (using password: NO).
This can happen if there is a space between the -p flag and the password.
If your password contains spaces, wrap it in double quotes.

[jbtronics]

The easiest way would probably to just use Part-DBs builtin backup capability.