Linux - backup ALL MySQL databases
mysqldump -u root -h localhost -pMyPassword -A | gzip -9 > allmy-db.sql.gz
backup all database from srv to allmy-db.sql.gz file!
———-
To restore compressed backup files you can do the following:
gunzip < allmy-db.sql.gz | mysql -u root -pMyPassword
or uncompress gz file: gunzip allmy-db.sql.gz
and use:
mysql -u root -pMyPassword -h localhost -A < /path/allmy-db.sql
or
mysql -u root -pMyPassword -h localhost -e “source /path/allmy-db.sql” -A
