Creating a database backup
The easiest way is to use Magento’s inbuilt tool. Go to System > Tools > Backups and select “Create Backup”.
If this is your first backup, it’s a good idea to verify that your backup is working correctly on a separate database.
You can also use other tools such as
If you use
Once the backup is finished, you will find the zipped backup under var/backups: