How to backup database from the back office in Prestashop 1.7.x?

The following steps will show you how to backup database from the back office in Prestashop 1.7.x

Part I.
1/. Go to back office admin portal
2/. Under the “CONFIGURE” section, click “Advanced Parameters” and “Database”
3/. Click “DB Backup” tab
4/. Click “I have read the disclaimer. Please create a new backup”
5/. After step 4, you see a link “Download the backup file (xxx MB) and click on it. You will start to download a data file like xxxxx.sql.bz2

Database backup is complete. If you database size is large, you may get an error “Interal Server Error”. In this case, you need to set the execute time in php.ini from php or httpd-default.conf from apache

Apache (httpd-default.conf)
Timeout 3600

Php (php.ini)
max_execution_time = 3600

** Attention: please clear your cache and use incognito/private mode in your browser