Resetting Hasura migrations

If you have too many migrations and want to squash them or your current migration state on the local machine is corrupted, you can reset the state and create new migrations from the state that is on the server.

Delete all the contents of your local migrations directory.

$ rm migrations/*

On the SQL tab of console, execute the following statement:

TRUNCATE hdb_catalog.schema_migrations;

Setup fresh migrations by taking the schema and metadata from the server:

## (available after version alpha45)
## create migration files (note that this will only export public schema from postgres)

$ hasura migrate create "init" --from-server

## note down the version
## mark the migration as applied on this server

$ hasura migrate apply --version "<version>" --skip-execution

If you are using schemas other than public, use --schema "schema_name" flag to indicate each one of them in the create command. This flag can be used multiple times. See more details about the usage in the docs.

Execute the following command to verify status of migration:

$ hasura migrate status

You have brand new migrations now!

This can also be used to combine (kind of squash) all of your migration files into a single one. You're snapshotting the state of a server and adding it as a new migration.