i would like to save all grants of a server when i do the DBs backup (it runs every night)
While mysql and mysqldump commands have an extrafile option that permit to use a file like this
that automatically pass the user/password information if using mysql (client) or nysqldump command
This is not available on pt-show-grants it has only -p option or i don’t find the right option to specify a file with credentials inside.
I know it can be a security issue put credentials on a file, but in this case i prefer to have it.
I know also that these information are on the information_schema DB that i backup every night, but it would be easier to recover from a SQL file if i need anyway.
Let me know if it is possible also with pt-show-grants command.
Thanks in advance