Hi Tasha There are a lot of tools you can choose from like phpmyadmin or mysql workbench Note that those tools give you full access (read/write) to the database so be careful when using them, Better use a database user that only has read access if you don't intend to do modifications. Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mer. 13 janv. 2021 à 19:13, Bales (US), Tasha R <tasha.r.bales@boeing.com> a écrit :
Thanks Alvaro. I’m coming from Millennium, where I know where everything “is”. I’m sure it will just take me some time to explore files and the database to see where everything “is” in Koha. We are currently experimenting in desktop VM’s, VirtualBox. We may not want to or be able to copy anything to our “real” server in the cloud on our corporate network. I may just keep up the copy/paste, as there’s not anything incredibly distinct and critical that I need to record.
A dumb question: with my old Oracle database, I was accustomed to being able to browse tables and just see what was what using Oracle SQL Developer. Do you all use Toad, or some other utility, to query and work with MariaDB in a GUI?
Thank you so much for your time,
*Tasha R. Bales*
*From:* Alvaro Cornejo [mailto:cornejo.alvaro@gmail.com] *Sent:* Wednesday, January 13, 2021 4:41 PM *To:* Bales (US), Tasha R <tasha.r.bales@boeing.com> *Cc:* koha@lists.katipo.co.nz *Subject:* [EXTERNAL] Re: [Koha] Koha web admin changes saved to master *.conf file?
EXT email: be mindful of links/attachments.
Hi Tasha
If you do change parameters through the admin interface, you can check the audits log in tools menu. There are several things you can check on there. Not sure if you need to enable them in system preferences.
All parameters, koha config as well as biblio database are stored into your mysql/maría db. So you can "simply" copy the database from your VM to your real server and it will be identical in terms of koha info/config but not config files or anything related to the server OS.
If you do manually edit any config file, there is no backup/change trace of it. You should backup files manually before editing.
Hope this helps.
Regards
Alvaro
|----------------------------------------------------------------------------------------|
Stay safe / Cuídate/ Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure.
*q* Recycle always / Recicla siempre / Recyclez toujours
P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire
Le mer. 13 janv. 2021 à 17:27, Bales (US), Tasha R < tasha.r.bales@boeing.com> a écrit :
Good afternoon,
I'm configuring a new Koha instance and am interested if the changes made via the web admin interface, such as Circulation settings, are all saved to a consolidated file on the server. Whatever changes I make, I'd like to reproduce them when I have the chance to move from a VM to a real server. For now, I am copying/pasting. However, I thought perhaps there is an easier, neater way to keep track of any changes I make from the defaults. I'm still new to navigating all the documentation, so please pardon me if I've missed the obvious.
Thanks for your time!
Tasha R. Bales
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha