Dump
cd c:\program files\mariadb 10.4\bin
mysqldump -uroot -p –-all-databases > c:\backup\local_db\20210123.sql
Note:
- Execute this command in “command promp” not in “mysql client”
- No “;” in the end!
Restore
mysql -u username -p dbname < c:\backup\local_db\20210123.sql
mysql -u root -p < c:\backup\local_db\20210123.sql
Reference: