Been using MySQL DB for gnu cash for many years, mainly because of security. Never had a problem. Very reliable and fast on my lan server. Not sure how fast over internet.
On Tue, Mar 12, 2019 at 7:37 PM John Ralls <[email protected]> wrote: > > > > On Mar 12, 2019, at 3:39 PM, Jacob Larsen <[email protected]> wrote: > > > > Hi > > > > How reliable is my data if I move from an XML file to a mysql database? > I just tried saving my books in a mysql (MariaDB) database, reload from the > database, and then saving back to an XML file. The files are of the same > size, and they have a large chunk that is identical on both sides in my > difftool. But there is also a large chunk that differs, so most likely the > order is shuffled. I started xmldiff on it just to see what it finds, but > that tool has not yet returned. > > > > Does anyone here know if there are any issues with data reliability when > saving data in a mysql database? > > > > Also, do you happen to know a difftool for xml files that runs faster > than xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I have > lying around, and it is still running for the last hour or so. > > > > Jacob, > > The list of open SQL backend bugs is > https://bugs.gnucash.org/buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=NEEDINFO&bug_status=REOPENED&component=Backend%20-%20SQL&list_id=3199&query_format=advanced. > AFAICT none affect data integrity. > > Regards, > John Ralls > > > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
