> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://docs.clientexec.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Auto Backup Clientexec Database

This will automatically generate a file with an SQL dump of your Clientexec database on a periodic basis, and deliver it to the location you set.

1. First ensure you set up the cron job on your cPanel, Directadmin or other panel. You can find those details [here](/en/article/how-to-set-up-cron-job-apnpq/).
2. Next, go to **Settings** > **Plugins** > **Automation Services** and in the dropdown select **CE Database Backup**.

![](https://storage.crisp.chat/users/helpdesk/website/-/8/9/5/a/895a2775afb3f800/screenshot-2026-07-28-at-15-46_p9crgi.png)

3. Select **Yes** for enabled in order to activate this feature. And go through the other options:

| Field Name | Description |
| ---- |
| Compress files with gzip | Only possible if you have the zlib extension in your PHP installation. |
| Encryption password | Enter a password if you wish to encrypt the file, or else leave empty. The password MUST be exactly 24 characters long. |
| Deliver to remote FTP or SFTP account | To send the files to a remote FTP or SFTP account enter the host and your credentials in the format ftp://username:password@host.com/subdirectory for FTP or sftp://username:password@host.com/subdirectory for SFTP SFTP is only possible if you have the ssh2 extension in your PHP installation |
| Deliver to local directory | To save the files in a local directory accessible and writable by the web server, enter it's full path here. |
| Deliver to E-mail address | To send the files as an E-mail attachment, enter the address here. |

4. The current settings for the cron will run this every morning at 1:30am (confirm your settings with the picture:)

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/screenshot-2023-04-03-at-10-50_1rabvds.png)

5. Click **Update Settings**.