Getting the below error when I try to restore data from backup. Pls help. Copying archive to tmp directory... Unzipping archive, this may take a while... tar: meta.json: Not found in archive tar: Exiting with failure status due to previous errors No metadata file to extract. EX…

Open the backup file and extract the dump.sql file from the dump.sql.gz. Open the dump.sql file and look for a block of numbers that gets inserted into the schema_migrations table. COPY public.schema_migrations (version) FROM stdin; 20000225050318 20120311163914 20120311164326 ... 20181031165343 20…

Did you rename the backup file?

I’m not sure about renaming. Maybe. Does it affects?

Yes, it stops the restore from working. That’s why you’re seeing the following error message. EXCEPTION: Migration version is missing from the filename. Can you rename it back to the original filename?

[图片] gerhard: Can you rename it back to the original filename? I don’t know the original filename. Also, I don’t have access to old server. I’ve the .gz backup file only. Any way to find the filename or any other way resolve this?? Thank you.

Thanks a ton man. :pray: :pray: :pray: :pray:

无法从备份恢复，因为备份文件已被重命名

支持

SMT 2018 年12 月 7 日 17:14 8

Thanks a ton man.

话题		回复	浏览量
Migration version is missing from the filename – can't restore from backup Support	9	1680	2018 年1 月 8 日
Backup Suggestions - Make a large flashing sign to not rename your backups Support	6	562	2021 年3 月 5 日
Restore from old version to a new version of discourse failed Self-hosting	16	2751	2019 年12 月 16 日
Exception during restore: EXCEPTION: undefined method `[]' for nil:NilClass Support	5	1986	2015 年10 月 2 日
Wrong version number on backup? Support	3	577	2020 年6 月 16 日

无法从备份恢复，因为备份文件已被重命名

相关话题