Magento 2 || Extract database - mpaz-redstage/magento-snippets GitHub Wiki

Extract database and compact

Using https://github.com/netz98/n98-magerun2

-bash-4.2$ /opt/rh/rh-php72/root/usr/bin/php -d memory_limit=3G ~/n98-magerun2.phar db:dump --compression="gzip" --strip="@stripped" --add-time="suffix"

Using mysqldump

mysqldump --user=root --single-transaction cupid-dev | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | gzip > dump_cupid.sql.gz