Backup MySQL Database

[DrByte]

Thanks! It is not working for me.
I get an error message and an empty gzip file saved in the admin/backups directory.
Here's the error message . . .

Result code: 2
0 => mysqldump: Got error: 1045: Access denied for user 'xxx_yyy'@'localhost' (using password: YES) when trying to connect
Failure: The database has NOT been saved.

Any ideas?

My vitals
1. Zen Cart v1.5.5a fresh clean install including demo data; files uploaded via FTP then run zc_install
2. Linux Apache
3. PHP Version: 5.6.17 (Zend: 2.6.0)
4. Database: MySQL 5.5.42-37.1-log

Could be that your database password (in DB_PASSWORD) contains a special character that's not translating well when the backup drops out to the command-line and passes the password parameter to do the database export. Anything in there like a $ or # or back-tick or quote/apostrophe or * or & might be problematic, depending on your server operating system.