restore a map

[fennyellow]

Hello everyone, near of 2 or 3 years ago, we were playing to a server named "the creative garden" with my family. This server is now close but the admin gave to us a backup of the map with database and an sql file and every mod. I have all file to restore it (I think) but I don't know how to do😅. I have tried a lot of things but nothing was succesful. Can somebody help me? Thanks à lot!
fenny

[Nininik]

What error(s) are you getting?

[Fenny]

I have 2 .dat files and an sql file with a text in but I don't understand how to use it. Do you want some pictures of it?

[Blockhead]

Fair warning, pretty much unavoidably, you will be given advice about using command-line programs if you hope to get the server back up, or probably even loading it in singleplayer.

I have 2 .dat files and an sql file with a text in but I don't understand how to use it. Do you want some pictures of it?

.dat isn't a common extension in the base engine, but maybe those files belong to a mod. .dat is often a really generic three letter combination that could be all sorts of things. Tell us all of the filenames, and try to run a program that tells you about what type of file they are, like GNU File (available on Linux, or in packages like Git Bash, Homebrew, Cygwin, or Windows Subsystem for Linux) or TrID.

One would usually expect 4 databases: auth.sqlite, map.sqlite, mod_storage.sqlite and players.sqlite. However, that goes for singleplayer on the defaults; multiplayer servers often use PostgreSQL for the world, which (if applicable) you hopefully have received in a format that unpacks into directories.

Some background reading

• World format
• Database Backends

[Fenny]

I did what you said and I have a "PostgreSQL custom database dump - v1.14-0" for the file toc.dat and an "ASCII text, with very long lines (4372)" for the 3315.dat file. I have too a SQL file with instruction in. I made everything writing but I don't have any result of it. I am block at this line : COPY public.blocks (posx, posy, posz, data, mtime) FROM '$$PATH$$/3315.dat';. I have written de path but I have a error message who said the my permission are denied to read the file. Can someone help me? Do you want the SQL file with instruction? Thanks a lot for your answers :)