Page 1 of 1

Problem using sqlite map online backup

PostPosted: Sun Sep 21, 2014 14:18
by 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?

Re: Problem using sqlite map online backup

PostPosted: Sun Sep 21, 2014 14:28
by 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.

Re: Problem using sqlite map online backup

PostPosted: Sun Sep 21, 2014 14:47
by lag01
Krock wrote: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...

Krock wrote: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.

Re: Problem using sqlite map online backup

PostPosted: Sun Sep 21, 2014 14:59
by Krock
lag01 wrote:
Krock wrote: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.

Re: Problem using sqlite map online backup

PostPosted: Sun Sep 21, 2014 15:21
by lag01
Ok, thanks.
No olnine backup then, too bad :(

Re: Problem using sqlite map online backup

PostPosted: Mon Sep 22, 2014 17:30
by 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 :)

Re: Problem using sqlite map online backup

PostPosted: Mon Sep 22, 2014 17:55
by 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.