I deleted the mysql field and ruined the database. How to initialize the data and fields?

Hao_Tan · April 21, 2021, 6:37am

RicardoE105 · April 21, 2021, 7:15pm

Delete the tables TypeORM created and then restart n8n. It should create all the table structures again.

Hao_Tan · April 22, 2021, 2:23am

Delete the mysql field? It seems to have no effect

RicardoE105 · April 22, 2021, 1:20pm

Not the fields. You have do delete the tables in the database.

Hao_Tan · April 25, 2021, 2:13am

I deleted the table.

Work can still be created, but the database has no tables and no data.

I don’t understand where the data is saved.

My .env is also set to mysql

Hao_Tan · April 25, 2021, 3:57am

Found the reason, n8n does not read the .env environment variables.
I am in cli/config/index.ts
The database driver and password have been modified.
Finally solved the problem