Backing up all your MySQL databases one by one is a pain. Here is a small bash script I made to dump and compress all my databases to my folder.
Bash script to backup all your MySQL databases
Responder
Backing up all your MySQL databases one by one is a pain. Here is a small bash script I made to dump and compress all my databases to my folder.
Generar archivo my.cnf
[client]
user=user
password=secret
routines
databases
Es conveniente cambiar permisos a este archivo con el comano
chmod 600 my.cnf
mysqldump --defaults-extra-file="my.cnf" database1 database2 database3 > database.sql