backup

[abhinavty123]

in superset can i get all data backup like database ,charts, datasets,users and theirs roles and permissions
. if any one know plz help..i need backup of my all data

[dosubot[bot]]

Hi @abhinavty123! I'm Dosu and I’m helping the superset team.

You can back up all your Superset data, but there are a few things to know. Superset stores everything—including charts, dashboards, datasets, users, roles, and permissions—in its metadata database (like PostgreSQL, MySQL, or SQLite). The only way to get a full backup (including users, roles, and permissions) is to back up this entire metadata database using your database's backup tools (for example, pg_dump for PostgreSQL or mysqldump for MySQL) source.

Superset also provides CLI commands to export/import dashboards and datasets as ZIP files (superset export_dashboards, superset export_datasources, superset import_dashboards, superset import_datasources). These are useful for migrating or sharing dashboards and datasets, but they do not include users, roles, or permissions source.

When restoring, you may need to manually reassign ownership of dashboards and datasets, since user IDs are not automatically mapped during import. Also, if you use the web UI or API for imports, there are file size limits (100 MB ZIP, 200:1 compression ratio), but the CLI bypasses these limits source.

So, for a full backup: dump your metadata database. For dashboard/dataset migration: use the CLI export/import commands.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}