MariaDB and MySQL database backup

Posted by in Lagom

mysqldump -u USER -pPASSWORD --single-transaction --quick --skip-lock-tables --ignore-table=DATABASE.some_table DATABASE | gzip > "$(date +"%Y-%m-%d_%H-%M-%S").sql.gz"