Thank you, the IT manager proceeded with the hint and I am now able to access mysql to clean the DBMS increment issues.
Kind regards *Decka David* On Thu, Mar 23, 2023 at 10:39 AM Hector Gonzalez Jaime <ca...@genac.org> wrote: > You need to add a line to one of mysql's configuration files, you may > create one just for this, the complete file would look like: > > [mysqld] > init-file = /var/lib/mysql/init-file_library.sql > > you may change "library" with your own libraries name. > > And you must create that file, with the sql from the wiki. > > from the error message, my guess is your sysadmin put this line outside > the scope of a [mysqld] section. [mysql] is not good enough, as it > refers to mysql's CLIENT program, not your database server. > > > On 3/21/23 20:59, Decka David wrote: > > Dear Koha Community, > > > > Here is a problem that someone here in this community might come across > or > > know to share how to solve this problem; I talked with my ICT > administrator > > to solve this issue to have access to the koha mysql but was unable to do > > so to fix the DBMS auto increment problem. The issue of the "unknown > > variable" in the script is; > > > > *mysql: [ERROR] unknown variable > > 'init-file=/var/lib/mysql/init-file_koha_library.sql'* > > > > I can do the mysqldump and run the backup on the test server but on the > > production server, I have no access at all. > > Looking into the past forum emails, wikis there is not much help. > > > > Thanking everyone here in advance for their invaluable insight and > pointing > > me towards solving the problem. > > > > Kind regards > > > > > > > > *Decka David* > > Matheson Librarian | PNG University of Technology | PMB | Lae, 411 | > Morobe > > Province | PAPUA NEW GUINEA > > Alternate E: decka.da...@gmail.com | P: 657 4734353 > <%28657%29%20473-4353> | > > F: 675 4374363 > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > Hector Gonzalez > ca...@genac.org > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
