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: