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 mysqldump (via the command line) or phpmyadmin to take a backup of your database. 

If you use phpmyadmin, be sure to tick the “Disable Foreign Key Constraints” box to be able to properly restore the backup. Depending on your database size and server speed, this may take a while. 

Once the backup is finished, you will find the zipped backup under var/backups: