https://www.linode.com/docs/databases/mysql/use-mysqldump-to-back-up-mysql-or-mariadb/
Backup db
mysqldump -u [username] -p [databaseName] > [filename]-$(date +%F).sql
Restore db
mysql -u [username] -p [databaseName] < [filename].sql
gunzip < localhost.sql.gz | mysql -u [username] -p