There are times when the usual methods of backing up a database do not cut the mustard – especially when it comes to Magento databases. Normally a Magento database can be backed up via the tool>backups module within the backend – however you may find that on some servers the process of backing up the database might time-out in your browser.
At times like these it is useful to know the following techniques for backing up and restoring via SSH.
First of all to backup your database you will need to firstly connect to your website via SSH – normally like so (on MAC):
– enter your password
This will normally get you in to your website – that is if you have SSH enabled for your domain on your chosen hosting platform.
Next we will perform a nice clean backup – what I tend to do if it is a Magento website is to navigate to the backups folder within the Magento var folder by doing the following: