Is it possible to add the MySQL Administrator password to the “bench restore” command as an argument?
I am moving fresh database backups to a hot spare server every hour during the business day.
I would like to be able to set a con job to chdir to the frappe-bench directory and run the bench restore command (and include the password on the command line).
This would make it pretty easy to jump to a backup server instance when it is already no more than an hour behind the primary server.
I could setup a script to take on restoring the backup (as long as I can find a way to include password)
This would keep a running server less than an hour behind the primary server and ready to take over if the need arose.
I am open to ideas on this one. This is a v10 production system. I have everything else working. I just need to figure out hos to do most of the startup with a single script
This worked exactly the way wanted. I posted the command syntax here for anyone else that may want to use a single command in the future as a way to semi-automate the process.
Thank you again for the pointer to the correct answer.