Re: [GNC] MariaDB?
Yes, Adrian, I probably could have just gone in search of the folder somewhere deep within the WAMP stack's folder tree and copied that over. Not really sure where MariaDB stores its data, though. And to be honest here, I'm just being lazy. As a career-long IT guy, I certainly can figure this stuff out. It just seemed less of a hassle to do a save to xml on the desktop, then open that from remote, and save again as MySQL on the new computer. Doesn't seemed to have lost anything in the translation. I have all my reports and theme back after following the suggestion to get it from the AppData folder rather than the User/.gnucash folder. All is good. (until I find otherwise, that is, lol) On Fri, Jul 29, 2022 at 12:46 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I thought MariaDB was supposed to be a 'drop-in' replacement for MySQL. > > Was it really necessary to use XML in the migration? > > Frank has already pointed you to the config wiki page, but for the > theme, check the FAQ on the wiki. There's an entry in the 'Customizing' > section that will lead you to how to edit or specify the theme. > > Regards, > Adrien > > On 7/28/22 10:36 AM, Thomas Forrester wrote: > > I installed MariaDB and GnuCash on the new computer, then on the old > > computer, I saved my financial data from MySQL to an XML file. > > > And second is that I've lost my dark mode theme and will > > have to dig around to try to remember how I got that to work in the first > > place. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
Re: [GNC] MariaDB?
I thought MariaDB was supposed to be a 'drop-in' replacement for MySQL. Was it really necessary to use XML in the migration? Frank has already pointed you to the config wiki page, but for the theme, check the FAQ on the wiki. There's an entry in the 'Customizing' section that will lead you to how to edit or specify the theme. Regards, Adrien On 7/28/22 10:36 AM, Thomas Forrester wrote: I installed MariaDB and GnuCash on the new computer, then on the old computer, I saved my financial data from MySQL to an XML file. And second is that I've lost my dark mode theme and will have to dig around to try to remember how I got that to work in the first place. ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] MariaDB? .gnucash folder
Ooooh! There they all are, and my dark theme, too! Thank you for the link. Very helpful when you're looking at the correct documentation, lol. Regards, Tom On Thu, Jul 28, 2022 at 6:10 PM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Hello Thomas, > > Am 28.07.22 um 17:36 schrieb Thomas Forrester: > > First is > > that the saved report configurations did not come across even though the > > .gnucash folder was copied over per the docs to the same location on the > > other computer. > > See https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DIR > > Regards > Frank > ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] MariaDB? .gnucash folder
Hello Thomas, Am 28.07.22 um 17:36 schrieb Thomas Forrester: > First is > that the saved report configurations did not come across even though the > .gnucash folder was copied over per the docs to the same location on the > other computer. See https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DIR Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] MariaDB?
Just finally reporting back on this change in my environment (new install on Windows 11 from an older Windows 10 computer running MySQL). Perhaps it will help others making similar changes to what I've just done. I'm moving on to a new computer and just didn't want to install the entire WAMP stack just to get MySQL. As someone who has also done a fair amount of web development, WAMPServer has been the convenient way to get MySQL and the rest of the development stack in place. That's not as relevant to me anymore, so I'm moving on without the stack. I had also heard MariaDB might be a better choice, especially since I only need the SQL part of the stack. I installed MariaDB and GnuCash on the new computer, then on the old computer, I saved my financial data from MySQL to an XML file. I copied that .gnucash file to the new computer. I also followed the guidance in the documentation (2.6. Migrating GnuCash data) to export/import preferences data from the registry, and copied the username/.gnucash folder to retain saved reports. All that complete, I opened the new installation of GnuCash. It opened just fine, and I immediately saved it to MySQL which brought up the MariaDB login requesting the server name, database name, username, and password. It saved the data without complaint. Closing and reopening GnuCash then gave me the SQL login prompt which worked fine and all is well with the data. Only two issues with the migration. First is that the saved report configurations did not come across even though the .gnucash folder was copied over per the docs to the same location on the other computer. And second is that I've lost my dark mode theme and will have to dig around to try to remember how I got that to work in the first place. Both are relatively minor issues. Thanks to the dev team for making the process relatively easy to comprehend and execute. This is not the kind of data you want to have go south on you, and to be able to fluidly move between MySQL and XML made the transfer quite painless. Tom Middleton, WI USA On Fri, Jul 15, 2022 at 9:47 PM john wrote: > None known; in fact we switched the connectors in the Gnucash-built > bundles and in flatpak to MariaDB's because MySQL discontinued their C one > and the C++ one won't work with libdbi. > > Regards, > John Ralls > > > On Jul 15, 2022, at 7:40 PM, Thomas Forrester > wrote: > > > > Are there issues with using MariaDB in place of MySQL? > > > > Thanks. > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > 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 gnucash-user@gnucash.org 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.
Re: [GNC] MariaDB?
On 2022-07-15 19:46, john wrote: None known; in fact we switched the connectors in the Gnucash-built bundles and in flatpak to MariaDB's because MySQL discontinued their C one and the C++ one won't work with libdbi. Regards, John Ralls On Jul 15, 2022, at 7:40 PM, Thomas Forrester wrote: Are there issues with using MariaDB in place of MySQL? I'll second John's comment. My system is Debian, so when I switched to using a database, it was MariaDB from the start. Never a problem. Cheers Cam Ellison ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] MariaDB?
None known; in fact we switched the connectors in the Gnucash-built bundles and in flatpak to MariaDB's because MySQL discontinued their C one and the C++ one won't work with libdbi. Regards, John Ralls > On Jul 15, 2022, at 7:40 PM, Thomas Forrester wrote: > > Are there issues with using MariaDB in place of MySQL? > > Thanks. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
[GNC] MariaDB?
Are there issues with using MariaDB in place of MySQL? Thanks. ___ gnucash-user mailing list gnucash-user@gnucash.org 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.