Page 1 of 1

Restore Database

Posted: Wed May 11, 2005 6:39 pm
by voripteth
How much success do you have with restoring the NewsPro database and having most of the data intact? When I do this my number of articles drop from the tens of thousands to a few dozen. Is this by design or am I doing something wrong?

Posted: Thu May 12, 2005 9:24 am
by alex
if you invoke file menu->save database&restart it will restore that point, otherwise it will be the session starting point.

Posted: Fri May 20, 2005 7:27 pm
by voripteth
What do you mean by "session"?

NewsPro certainly does not restore itself to the state when I last started the program. I don't end up with an entirely empty database either which also seems odd. It just has a few dozen articles in various groups. Perhaps restore just restores the headers downloaded during the last session? (Not very useful if that's the case.)

I do find this an issue since my system recently automatically rebooted after a system update while running NewsPro overnight. The tens of thousands of headers previously saved in the database has been reduced to a mere dozen.

Is there any way to make the database a bit more robust so it can survive an abnormal exit from the software without losing 99% of the data?

--append--

I just read a post where the user says that database restore works fine for him. Just to be clear, I have NEVER had the database restore function restore even 1% of of my previous data. Is this working as you expect?

Posted: Sun May 22, 2005 1:23 pm
by edfreeman
I presume you're not using the database backup function . . . that is the only way, methinks, to restore back to a session start.

Posted: Sun May 22, 2005 4:44 pm
by voripteth
Looking at the file menu I can see Optimize, Reset and Switch. I don't see any function labelled "Backup". Are you referring to the "Save and Restart" function? This seems a bit extreme if its the only backup option. Shouldn't NewsPro save a backup on exit at the very least?

In short I think that the NewsPro database should be made robust enough to survive an abnormal termination of the program without losing nearly all the data.

Posted: Sun May 22, 2005 7:48 pm
by Josef K
Properties->General->Database backup (checkbox on the far right).

Posted: Tue May 24, 2005 11:18 am
by voripteth
Thanks for the pointer! I did find the checkbox and have turned it on. We'll see what difference it makes.

It sure was a hard to find option!