Well here is a practical example of how to back up all your databases quickly
Command explanation
- "USER" == User registered in mysql can be root or the one who has permissions
- «PASSWORD» == User password
- «–All-databases» == We indicate the databases to back up (with this backs up all)
- "192.168.1.202" == In my case the ip of the server to back up
- «/ Var / BACKUP_MYSQL / mysql-$ (date + \ %d- \ %m- \ %Y) .sql» == The destination path where backup will be saved
We open the console
Practical code
[mysql @ local drive ~] # mysqldump -uUSER -p PASSWORD --all-databases -h 192.168.1.202> / var / MYSQL_SUPPORT / mysql-$ (date + \ %d- \ %m- \ %Y) .sql
Example with a single database
[mysql @ local drive ~] #mysqldump -uUSER -p PASSWORD -h 192.168.1.202 --databases DATA_BASE_NAME> / var / MYSQL_UPPORT / mysql-$ (date + \ %d- \ 1TPlTD1TY). .com/
No Comment