mealie-recipes / mealie

Mealie is a self hosted recipe manager and meal planner with a RestAPI backend and a reactive frontend application built in Vue for a pleasant user experience for the whole family. Easily add recipes into your database by providing the url and mealie will automatically import the relevant data or add a family recipe with the UI editor
https://docs.mealie.io
GNU Affero General Public License v3.0
7.31k stars 729 forks source link

Lost my user credentials, can't access database #4123

Closed amca01 closed 1 month ago

amca01 commented 2 months ago

Hello,

I recently had some issues with my VPS, which required a reboot; also I've been tinkering with my caddy setup (for reverse proxy).

When I try to log in to mealie now, it claims that this appears to be a first login, and gives me the standard "changeme@example.com/MyPassword" credentials.

As far as I can see, the database is still there, and I've moved it to a local directory with a docker bind mount.

Can I import the database into a new user? I don't want to have to recreate all my recipes from scratch - there are too many of them. I'm no database expert (I'm no database anything really), but I don't mind using sqlite command line tools to manage the database, if that's a possibility.

Anyway, I'd like to have my old user credentials again, and with the current database. Happy to take advice!

(I hope all this makes sense.)

Thank you very much, Alasdair

michael-genson commented 2 months ago

You can change your password from the command line: https://docs.mealie.io/documentation/getting-started/faq/#how-can-i-change-my-password

amca01 commented 2 months ago

Many thanks for pointing that out. However, I can't extract any recipes from the database. Exploring it seems to indicate that it consists entirely of tables and schemas, but no data.

Maybe I will have to create all my recipes from scratch again, and this time be cleverer about backups - actually do them!

github-actions[bot] commented 1 month ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.