[Koha] Koha mysql DBMS fix

[Decka David]

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 <cacho at 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.david at gmail.com | P: 657 4734353
> <%28657%29%20473-4353> |
> > F: 675 4374363
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> --
> Hector Gonzalez
> cacho at genac.org
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>