[BUG] - Unable to migrate from MySQL to Postgres about mealie

[djmega152]

I'll give that a shot and report back.

[djmega152]

Confirmed as a config issue on my postgres deployment. I used a different docker compose than the one on the docs site. Once I defaulted to the one on the site, everything works as expected and the migration is complete. Thanks @Kuchenpirat for the assist! I've been toiling with this for months (on and off)

[djmega152]

If you'd like a copy of the MySQL backup export (.zip), let me know and I can either attach it here or send it directly.

[Kuchenpirat]

i think the right way to do this would be:

• create the backup on the sqlite instance on the /admin/backups page and download it
• go to the same page on the postgres instance
• use the upload button to upload the backup
• use the restore functionality on this page to restore from backup

[djmega152]

Nope, here's the logs from the mealie container:

12/30/2023 10:55:10 AM INFO: 30-Dec-23 10:55:10 initially backup restore 12/30/2023 10:55:10 AM ERROR: 30-Dec-23 10:55:10 [Errno 2] No usable temporary directory found in ['/tmp', '/var/tmp', '/usr/tmp', '/app'] 12/30/2023 10:55:10 AM Traceback (most recent call last): 12/30/2023 10:55:10 AM File "/app/mealie/routes/admin/admin_backups.py", line 105, in import_one 12/30/2023 10:55:10 AM backup.restore(file) 12/30/2023 10:55:10 AM File "/app/mealie/services/backups_v2/backup_v2.py", line 81, in restore 12/30/2023 10:55:10 AM with backup as contents: 12/30/2023 10:55:10 AM File "/app/mealie/services/backups_v2/backup_file.py", line 52, in __enter__ 12/30/2023 10:55:10 AM self.temp_dir = Path(tempfile.mkdtemp()) 12/30/2023 10:55:10 AM File "/usr/local/lib/python3.10/tempfile.py", line 357, in mkdtemp 12/30/2023 10:55:10 AM prefix, suffix, dir, output_type = _sanitize_params(prefix, suffix, dir) 12/30/2023 10:55:10 AM File "/usr/local/lib/python3.10/tempfile.py", line 126, in _sanitize_params 12/30/2023 10:55:10 AM dir = gettempdir() 12/30/2023 10:55:10 AM File "/usr/local/lib/python3.10/tempfile.py", line 299, in gettempdir 12/30/2023 10:55:10 AM return _os.fsdecode(_gettempdir()) 12/30/2023 10:55:10 AM File "/usr/local/lib/python3.10/tempfile.py", line 292, in _gettempdir 12/30/2023 10:55:10 AM tempdir = _get_default_tempdir() 12/30/2023 10:55:10 AM File "/usr/local/lib/python3.10/tempfile.py", line 223, in _get_default_tempdir 12/30/2023 10:55:10 AM raise FileNotFoundError(_errno.ENOENT, 12/30/2023 10:55:10 AM FileNotFoundError: [Errno 2] No usable temporary directory found in ['/tmp', '/var/tmp', '/usr/tmp', '/app'] 12/30/2023 10:55:10 AM INFO: 192.168.1.1:0 - "POST /api/admin/backups/mealie_2023.12.30.09.32.38.zip/restore HTTP/1.1" 500 Internal Server Error 12/30/2023 10:55:34 AM INFO: 127.0.0.1:47018 - "GET /api/app/about HTTP/1.1" 200 OK

[Kuchenpirat]

ok, two things.

• You said you have no problem passing along the zip. Could you send that over and i can give it a quick try on my system. Either here or on Discord
• Do you have more deployment deployment on your new instance. Do you have the volumes configured correctly?

[Kuchenpirat]

i got the zip off platform and could restore it on an postgres deployment.

Closing for now as i am pretty sure its an deployment error.

@djmega152 feel free to reopen, if it turn out to be something else.

[boc-the-git]

@djmega152 can you please share both the bad and good compose files here, for reference?
Could help others see what specific detail is wrong in the config.

Nice one @Kuchenpirat 👍