Magento 2 Backup and Restore: What to Save and How
How to back up and restore a Magento 2 store: database dumps that import cleanly, media, env.php and the encryption key, offsite copies and tested restores.
← Back to blog
Articles about MySQL
3 articles
Magento 2 MySQL Tuning: Settings and Slow Queries
Tune MySQL and MariaDB for Magento 2.4.8: buffer pool sizing, redo log, temp tables, binlog and triggers, finding slow queries and keeping tables lean.
Sanitize a Magento 2 Database for Staging and Local Dev
How to copy a Magento 2 production database to staging safely: anonymize customer and order data, disable email and integrations, swap secrets, block indexing.