MYSQL or MariaDB Database backup & Restore

Copying and importing a database

Copying the database

mysqldump -u database-user -p database-name  | gzip > /yourFolderLocation/`date "+%F"`.sql.gz

Increase the max allowed packet size

mysqldump -u root -p --quick --compress --max-allowed-packet=256m --skip-lock-tables database-name | gzip > /yourFolderLocation/`date "+%F"`.sql.gz

Importing the database

zcat /yourFolderLocation/database-name.sql.gz | mysql -u 'database user' -p database-name