How do I reset Superset's db?
I've been testing stuff out with Superset and I think I corrupted my superset db. When I try to acess any chart i get this error:
I found a workaround to this problem, by searching with ag - the silver searcher which individual migration dropped the dbs.perm table, and using the command
superset db downgrade <migration-id>
on the migration prior to that one.
It's still not very clear to me which steps I would take as to completely reset the db safely.
I have the manual, dev installation since I'm working on customizing the code. Let's say I didn't have anything too important in the db, so I'm not afraid to loose tables, users, perms, etc.
I've found I have a superset.db in ~/.superset, but I don't think deleting that will be enough, right?
How can I reset Superset's db so as to make a clean db and start over? Can I do this without losing my Superset installation, or do I need to start over completely? In any case, can you guide me through it?
You need not to reinstall everything. Just remove the ~/.superset/superset.db file and take the backup of this file before removing it just in case you want to restore it. and then run the below commands. These commands will create another database file.
Initialize the database
superset db upgrade
Create an admin user (you will be prompted to set a username, and first and last name before setting a password)
$ export FLASK_APP=superset
$ superset fab create-admin
Load some data to play with
superset load_examples
Create default roles and permissions
superset init
- Trying to upgrade SQLite on Amazon EC2
- How can I store data with nested object data in Android? [Room]
- Laravel Database Insert Error in artisan tinker
- interpret hex as numbers, when importing csv into sqlite3
- Simple export and import of a SQLite database on Android
- Get a list of field values from Python's sqlite3, not tuples representing rows
- SQLite querying using embedded C#
- How to do aggregate raw sql with julian date in sqlite (with django)
- How do I call SQLitePCL.Batteries.Init().?
- How can I access the sqlite3 database file in production with electron?
- How can I see which sqlite3 binary the sqlite3 Python module uses on Ubuntu 16.04?
- Non-interactive SQLite3 usage from bash script
- Why would SciPy stats.percentileofscore return an array instead of a scaler beginning with version 1.9?
- How do I remove NULL values when extracting JSON to generated columns?
- Cmake sqlite3 amalgamation
- SQLite DB creation issue after installation in JAVAFX based appication created in Eclipse
- Unable to open sqlite database file inside program
- What is the maximum number of connections for a SQLite3 database?
- How to retrieve the last autoincremented ID from a SQLite table?
- Foreign Key Constraints does not work with Doctrine/Symfony and SQLite
- How can I successfully pass a variable into my sqlite SELECT statement?
- Inserting a row and returning its primary key
- How to build sqlite3.dll with the command line in Windows with Visual C++?
- How to fix tzdb.dat not found error in java?
- Sqlite EF Core 5 won't let me do case insensitive searches
- How to concat columns in Sequelize with SQLite database
- Entity Framework SQLite Error 1: 'no such table: __EFMigrationsHistory'
- Database (database/database.sqlite) does not exist. Database works from artisan tinker
- SQLite3 Discord ID Precision Issue in TypeScript
- Creating composite data class from multiple Room/SQL queries (or one complex one)