I'm looking for an easy way to backup (and if needed restore) the databases of a Drupal multisite using Drush.
Drush command I use to backup all the databases:
drush @sites sql-dump --result-file --gzip
The backup of the databases seems to work. After executing the above command, databases are automatically stored in /root/drush-backups/DATABASENAME/TIMESTAMP/DATABASENAME_TIMESTAMP.sql.gz
What command can I use to restore the last backup of the databases automatically?
What is the best way to backup and restore the databases of a Drupal 7 multisite using Drush?
PS: I'm using Git, so I only need to backup databases.
Many thanks for your advice!