I deleted the mysql field and ruined the database. How to initialize the data and fields?
Delete the tables TypeORM created and then restart n8n. It should create all the table structures again.
Delete the mysql field? It seems to have no effect
Not the fields. You have do delete the tables in the database.
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
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