Problem using sqlite map online backup

[lag01]

Hello,
i almost got map online backup working (see attachment).
But there is problem, that backup never finishes, most likely because DB is written all the time, despite settings.
In minetest.conf i have these settings:

Your phone or window isn't wide enough to display the code box. If it's a phone, try rotating it to landscape mode.

Code: Select all

server_map_save_interval = 520
sqlite_synchronous = 0


I tough that means that minetest will write to database only every 520 seconds, but backups resets in few seconds!
Any ideas?

[Krock]

I'm sure, minetest won't write all changes at once.
It will spread the load and save little parts instead of all together.

A server shutdown script would be better to do backups.

[lag01]

I'm sure, minetest won't write all changes at once.
It will spread the load and save little parts instead of all together.

Then i don't get why those settings are there...

A server shutdown script would be better to do backups.

Well, i have things little more complicated...
So online backup really would help me there.

[Krock]

I'm sure, minetest won't write all changes at once.
It will spread the load and save little parts instead of all together.

Then i don't get why those settings are there...

They're there to define the waiting time of "the little part" until it gets saved again.

[lag01]

Ok, thanks.
No olnine backup then, too bad :(

[lag01]

Hurray!
Changing to

Your phone or window isn't wide enough to display the code box. If it's a phone, try rotating it to landscape mode.

Code: Select all

pagestocopy = 2500000

makes it work!
At least on my laptop.
Now i am going to test it on my live server :)

[lag01]

well....
first time that worked (making some lags on server).
When i run that second time(to sync to already existing backup file), it takes very long.