Steps:

1. Dump
   1. cd c:\program files\mariadb 10.4\bin
   2. mysqldump -u root -p –all-databases > d:\backup\dump20190712.sql
      Notice:
      1. Execute this command in “command promp” not in “mysql client”
      2. No “;” in the end!
2. Restore
   1. mysql –u username –p dbname < filename.sql
   2. mysql -u root -p < backup.sql

Advanced: dump partial data of each table:

How to get partial data from large MySQL databases using mysqldump

Reference:

1. https://john-dugan.com/dump-and-restore-mysql-databases-in-windows/
2. https://code.yidas.com/mysqldump/