mysql -u username -p database_name < file.sql
mysql dump
mysqldump -u username -p db_name > backup-file.sql
ar…for Synology MariaDB
/usr/syno/mysql/bin/mysqldump –user=$DB_USER –password=$DB_PASS
Schedule a Backup of all your MySQL databases on Synology:
http://www.beatificabytes.be/wordpress/schedule-a-backup-of-all-your-mysql-databases-on-synology/
====
to dump from .gz
zcat /path/to/file.sql.gz | mysql -u ’root’ -p your_database
( ref : https://serverfault.com/questions/137965/how-do-i-load-a-sql-gz-file-to-my-database-importing)
