Help Needed: How to Take SQL DB Dump for a Specific Module in ERPNext

[Soniya_K]

Hi, I’ve created a custom module in my ERPNext instance for my organization. It includes a Procurement application with doctypes for form creation, workflows for ticket changes, and email notifications. I need to back up only this specific module, not the entire site.

I tried using the command: bench --site sitename backup --with-files, which generated the following files:

• site.database.sql.gz
• site.private-files.tar
• site.localhost-files.tar
• site_config_backup.json

However, I need to dump just the specific module, not the full site backup. Any help on how to achieve this would be appreciated.

[ejaaz]

If you have created a custom app, you can export customization in your custom app via fixtures.

Export Custom field using export fixtures

Export Fixtures for doctype

in hooks.py fixtures = [ {"dt": "DocType", "filters": [ [ "name", "in", [ "Doctype1Name", "Doctype2Name" ] ] ]}, {"dt": "Custom Field", "filters": [ [ "name", "in", [ "CustomFieldName" ] ] ]} ] then run command bench export-fixtures

https://frappeframework.com/docs/user/en/guides/app-development/exporting-customizations