How to Create a Backup of All MySql or MariaDB Databases

Backing Up Your Databases:

Open your command prompt and use the following command to backup/dump all databases to a file you specify:

mysqldump --user=SOMEUSER --password=PASSWORD --all-databases > C:/TEMP/MySqlDumps/backup-all.sql      

Restoring Your Databases From Your Backup:

mysql --user SOMEUSER --password < C:/TEMP/MySqlDumps/backup-all.sql

Note: if you get errors, or the restore does not complete and you wish to force the restore to continue despite errors use the --force option:

mysql --user SOMEUSER --password --force < C:/TEMP/MySqlDumps/backup-all.sql