All Scheduled Transactions Disappear

[John Ralls]

> On Dec 28, 2016, at 8:20 AM, aeneas <receiver at gowdygroup.net> wrote:
> 
> OK!  Looking at 2 databases that I backed up.  The first one was the one that
> I was using when I identified the problem.  The second one is the one that
> my hosting service restored which they said was created on 12/17/2016.  The
> 12/17/2016 date was prior to the date when I first noticed the problem. 
> Therefore this database was unaffected by anything I did during the session
> when I was trying to find the missing scheduled transactions during which I
> also added several transactions which I expect are now gone from the
> restored database.
> 
> Running the query you requested resulted in an enter_date="2016-12-10
> 20:20:58" which was the same in both databases.  I also verified that the
> databases were different based on the fact that phpMyAdmin showed different
> counts for the number of rows in some of the tables.  However, the number of
> rows in all of the foo_back tables in both databases was the same, which
> suggests to me that they may have been the same.  What would you think?
> 
> I have to do a bit of work on my restored database with GnuCash before
> offering much of an opinion about how successful the restoration has been. 
> Possibly I should wait a bit and finish up this topic with some kind of
> assessment about how the results appear from the GnuCash perspective.  In
> the meantime, I have the 2 database instances referenced above (i.e., with
> the foo_back tables) sitting on my test system in a static (i.e., not being
> used) state.  If you think of other queries that might be helpful to the
> cause I'd be glad to run them.
> 

Yes, I think that the foo_back tables are unchanged since they were created, and I think that the safest thing to do would be to drop foo and rename foo_back to foo, then re-enter everything since December 10th. It's just over two weeks work so it shouldn't be too onerous.

Once that's done I don't think that there's any reason to keep the dead bodies around.

Regards,
John Ralls