You have no items in your shopping cart.
Database Backup - SQL Backup & Recovery Magento2 Extension
Magento2 Database Backup is a comprehensive database & recovery extension for your Magento2 store to automatically backup your store's database to the cloud of your choice.
Backing up your Magento2 store is critical to ensure that you back recover from any fatal server crashes or hacking incidents and get back online with your store and experience quickly. Magento2 Database Backup is designed to be a dead-easy db backup extension for Magento2 stores - so as a Magento2 administrator you can define your backup plan and see it all happen automatically on the schedule you have defined to the cloud you have chosen. Magento2 Database Backup is #1 in comprehensiveness - it backs up the database and save it on a predefined folder, email archive, ftp location, Amazon S3, Google Drive, Box.net or DropBox. It can also help in minimizing the fallout if the store has been compromised to quickly roll back Magento2 store on last good backup.
|Magento2 Store Backup Features|
|Upload database backups to Google drive|
|Upload backups to Box.net|
|Upload db backups to Dropbox|
|Upload store backups to Amazon S3|
|Upload backups to FTP|
|Upload to SFTP|
|Upload database backups to Local storage|
|Automatically remove old database archives, backup files|
|Schedule automatic backups|
|Magento2 automatic SQL backup|
|Backup email notification|
|Magento2 Database Backup Best Practices|
|Offsite backup reduces the risk of losing data or file by saving database backup copy on a server that is physically situated in other data center/city/country/on some other continent.|
|Avoid saving backups on the same server that hosts your Magento2 store.|
|Setting up CRON to periodically save the backups is critical.|
|Periodically restore from old database backups to verify the backup integrity.|
|Periodically plan a mock restoration & recovery exercise on a sandbox server.|
|Magento2 Database Backup: Common Problems, Scripts, Errors and more|
|Dropbox and box.com have specific restrictions regarding file size and number of calls. Ensure you have enough space available to support your database backup.|
|Ensure free space on the server not less than the size of the backup.|
|Older archives not being deleted: Ensure the script has proper ownership rights to delete older files.|
Magento2 Database Backup Restore & Rollback
To restore Magento2 shop from backup, you have two options that requires you to transfer Magento2 backup back from your FTP or Cloud account to your local machine or server.
Option 1. Magento2 db backup through phpMyAdmin
- Use FTP to download the .gz backup from
/var/backups/or download it from Cloud Server set up in the backup profile. If you store more than one backup, choose the necessary file by the creation date.
- Login to phpMyAdmin
- Navigate to store’s database
- Click the Import tab
- Click the Browse button, find your .gz file on your computer, and hit Go.
Option 2. Magento2 backup ssh to server
- Here’s another option for those who have a large database and shell access (SSH).
- Login to your SSH account (this can be done using PuTTY or KiTTY)
- Navigate to the
var/backupsfolder in your Magento2 installation (make sure the DB backup .sql file is in the right folder).
- Enter the following line:
gunzip < your backup.sql mysql -u root -p magentodb
- Console will ask you for the username’s password. Input username password and press Enter – the process of backup import will start immediately.
Magento 2 Database Backup Extension FAQ's
Can I backup my magento database on a defined schedule?Yes, with Magento database backup extension you can define the backup settings once and the extension automatically does the rest - on the defined schedule, it creates full backup of your Magento store's database and saves in predefined locations.
How often can I backup my Magento database?With Magento Sheduled Database Backup extension, you have the flexibility of defining how often you'd like to backup once, after that the extension backs up your full database based on defined interval.
What alternatives do I have to store my Magento SQL backup file?You can choose to store the backup of your Magento store in your email, on the same server as your store, on a FTP server or on external services like Amazon S3 backup, backup to Dropbox, Box Backup or Google Drive backup.
Do you recommend storing my store backup on same server running Magento?No, ideally we would recommend that you keep your Magento store backup on a separate location to protect against fatal server crashes. This way even if your server goes fully down you have your backup ready somewhere else.
Can I restore database backup with this extension?No, Current version does not support restore database backup feature. This feature will be coming soon in next version.
Can I have Magento Automatic Store Backup using this extension?No, current version of extension only supports backup MYSQL databases. Automatic store backup with files,folders, images etc are coming soon in next version.
Precise and to the point Review by Jimmy Roberts
You have nailed it Ken, i have been in that kind of situations myself. It took me a while to understand why i really need it and now i can't part of it.
Excellent plugin to manage database dumps automatically. It's just really peace of mind.
MUST have extension for serious stores Review by Ken
I have been in very bad situations in the past and i know the problems you face when you don't have backups and you have a store to run.
Tried few extensions in the past and this seems to be dong the job perfectly. I personally reloaded to verify the database dumps. All looks good. 5 stars to the plugin creator.